1. Tables and Views for HCM
  2. BEN_DIAG_FF_ATCHMNT_V

BEN_DIAG_FF_ATCHMNT_V

Details

  • Schema: FUSION

  • Object owner: BEN

  • Object type: VIEW

Columns

Name

Object Name

Object Type

Table Name

Column Name

Query

SQL_Statement

SELECT NAME "Object Name",

'Plan' "Object Type",

'BEN_PL_F' "Table Name",

'DFLT_TO_ASN_PNDG_CTFN_RL' "Column Name"

FROM BEN_PL_F

WHERE DFLT_TO_ASN_PNDG_CTFN_RL IN(SELECT FORMULA_ID FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID=(SELECT FORMULA_TYPE_ID

FROM FF_FORMULA_TYPES

WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName'))

))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Plan' "Object Type",

'BEN_PL_F' "Table Name",

'AUTO_ENRT_MTHD_RL' "Column Name"

FROM BEN_PL_F

WHERE AUTO_ENRT_MTHD_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Plan' "Object Type",

'BEN_PL_F' "Table Name",

'MX_WTG_DT_TO_USE_RL' "Column Name"

FROM BEN_PL_F

WHERE

MX_WTG_DT_TO_USE_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Plan' "Object Type",

'BEN_PL_F' "Table Name",

'MX_WTG_PERD_PRTE_DET_RL' "Column Name"

FROM BEN_PL_F

WHERE

MX_WTG_PERD_PRTE_DET_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE

AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Plan' "Object Type",

'BEN_PL_F' "Table Name",

'NIP_DFLT_ENRT_DET_RL' "Column Name"

FROM BEN_PL_F

WHERE NIP_DFLT_ENRT_DET_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Plan' "Object Type",

'BEN_PL_F' "Table Name",

'DPNT_CVG_END_DT_RL' "Column Name"

FROM BEN_PL_F

WHERE

DPNT_CVG_END_DT_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Plan' "Object Type",

'BEN_PL_F' "Table Name",

'DPNT_CVG_STRT_DT_RL' "Column Name"

FROM BEN_PL_F

WHERE

DPNT_CVG_STRT_DT_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Plan' "Object Type",

'BEN_PL_F' "Table Name",

'WHEREENRT_CVG_END_DT_RL' "Column Name"

FROM BEN_PL_F

WHERE ENRT_CVG_END_DT_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Plan' "Object Type",

'BEN_PL_F' "Table Name",

'POSTELCN_EDIT_RL' "Column Name"

FROM BEN_PL_F

WHERE

POSTELCN_EDIT_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Plan' "Object Type",

'BEN_PL_F' "Table Name",

'ENRT_CVG_STRT_DT_RL' "Column Name"

FROM BEN_PL_F

WHERE ENRT_CVG_STRT_DT_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Plan' "Object Type",

'BEN_PL_F' "Table Name",

'PRORT_PRTL_YR_CVG_RSTRN_RL' "Column Name"

FROM BEN_PL_F

WHERE

PRORT_PRTL_YR_CVG_RSTRN_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Plan' "Object Type",

'BEN_PL_F' "Table Name",

'RT_END_DT_RL' "Column Name"

FROM BEN_PL_F

WHERE RT_END_DT_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Plan' "Object Type",

'BEN_PL_F' "Table Name",

'RT_STRT_DT_RL' "Column Name"

FROM BEN_PL_F

WHERE

RT_STRT_DT_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Plan' "Object Type",

'BEN_PL_F' "Table Name",

'ENRT_RL' "Column Name"

FROM BEN_PL_F

WHERE ENRT_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Plan' "Object Type",

'BEN_PL_F' "Table Name",

'MX_WTG_PERD_RL' "Column Name"

FROM BEN_PL_F

WHERE MX_WTG_PERD_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Plan' "Object Type",

'BEN_PL_F' "Table Name",

'VRFY_FMLY_MMBR_RL' "Column Name"

FROM BEN_PL_F

WHERE VRFY_FMLY_MMBR_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Plan' "Object Type",

'BEN_PL_F' "Table Name",

'FRFS_DISTR_MTHD_RL' "Column Name"

FROM BEN_PL_F

WHERE FRFS_DISTR_MTHD_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Plan' "Object Type",

'BEN_PL_F' "Table Name",

'CVG_AMT_LMT_RL' "Column Name"

FROM BEN_PL_F

WHERE CVG_AMT_LMT_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Plan' "Object Type",

'BEN_PL_F' "Table Name",

'CVG_MLT_LMT_RL' "Column Name"

FROM BEN_PL_F

WHERE CVG_MLT_LMT_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Plan' "Object Type",

'BEN_PL_F' "Table Name",

'UNSSPND_ENRT_RL' "Column Name"

FROM BEN_PL_F

WHERE UNSSPND_ENRT_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Program' "Object Type",

'BEN_PGM_F' "Table Name",

'ENRT_CVG_END_DT_RL' "Column Name"

FROM BEN_PGM_F

WHERE ENRT_CVG_END_DT_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Program' "Object Type",

'BEN_PGM_F' "Table Name",

'ENRT_CVG_STRT_DT_RL' "Column Name"

FROM BEN_PGM_F

WHERE ENRT_CVG_STRT_DT_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Program' "Object Type",

'BEN_PGM_F' "Table Name",

'DPNT_CVG_STRT_DT_RL' "Column Name"

FROM BEN_PGM_F

WHERE DPNT_CVG_STRT_DT_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Program' "Object Type",

'BEN_PGM_F' "Table Name",

'DPNT_CVG_END_DT_RL' "Column Name"

FROM BEN_PGM_F

WHERE DPNT_CVG_END_DT_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Program' "Object Type",

'BEN_PGM_F' "Table Name",

'RT_STRT_DT_RL' "Column Name"

FROM BEN_PGM_F

WHERE RT_STRT_DT_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Program' "Object Type",

'BEN_PGM_F' "Table Name",

'RT_END_DT_RL' "Column Name"

FROM BEN_PGM_F

WHERE RT_END_DT_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Program' "Object Type",

'BEN_PGM_F' "Table Name",

'AUTO_ENRT_MTHD_RL' "Column Name"

FROM BEN_PGM_F

WHERE AUTO_ENRT_MTHD_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Program' "Object Type",

'BEN_PGM_F' "Table Name",

'ENRT_RL' "Column Name"

FROM BEN_PGM_F

WHERE ENRT_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Program' "Object Type",

'BEN_PGM_F' "Table Name",

'VRFY_FMLY_MMBR_RL' "Column Name"

FROM BEN_PGM_F

WHERE VRFY_FMLY_MMBR_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Program' "Object Type",

'BEN_PGM_F' "Table Name",

'DFLT_STEP_RL' "Column Name"

FROM BEN_PGM_F

WHERE DFLT_STEP_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Program' "Object Type",

'BEN_PGM_F' "Table Name",

'SCORES_CALC_RL' "Column Name"

FROM BEN_PGM_F

WHERE SCORES_CALC_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))

AND TO_DATE(TO_CHAR(FND_DIAG_SDK_API.GET_DATE_INPUT_PARAM('effectiveDate'),'DD-MM-YYYY'),'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

UNION ALL

SELECT NAME "Object Name",

'Program' "Object Type",

'BEN_PGM_F' "Table Name",

'SALARY_CALC_MTHD_RL' "Column Name"

FROM BEN_PGM_F

WHERE SALARY_CALC_MTHD_RL IN(select formula_id FROM FF_FORMULAS_F

WHERE FORMULA_TYPE_ID = (SELECT FORMULA_TYPE_ID FROM FF_FORMULA_TYPES WHERE UPPER(FORMULA_TYPE_NAME) LIKE UPPER(FND_DIAG_SDK_API.GET_VARCHAR2_INPUT_PARAM('formulaTypeName')) ))