View: BEN_PNDG_WRKFLW_APPRVLS_V

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BEN_PNDG_WRKFLW_APPRVLS_V

View Text

SELECT VLV.NUMBER_VALUE PERSON_ID
, VLV1.NUMBER_VALUE ELIG_PER_ELCTBL_CHC_ID
, VLV2.NUMBER_VALUE BNFT_AMT
, VLV3.NUMBER_VALUE RT_VAL
, VLV4.VARCHAR2_VALUE PL_OPT_NAME
, VLV5.DATE_VALUE ENRT_CVG_STRT_DT
, VLV6.DATE_VALUE RT_STRT_DT
, VLV7.DATE_VALUE RT_END_DT
, VLV8.NUMBER_VALUE LIMIT_RT_VAL
, VLV9.VARCHAR2_VALUE JUSTIFICATION
, VLV10.VARCHAR2_VALUE FREQUENCY
, VLV11.VARCHAR2_VALUE RT_UOM_MEANING
, VLV12.VARCHAR2_VALUE BNFT_UOM_MEANING
, VLV13.VARCHAR2_VALUE ACTY_REF_PERD_MEANING
, VLV14.VARCHAR2_VALUE BNFT_TYP_MEANING
, VLV.CREATION_DATE CREATION_DATE
, VLV.CREATED_BY CREATED_BY
FROM WF_ITEM_ACTIVITY_STATUSES PROCESS
, WF_ITEM_ACTIVITY_STATUSES PROCESS2
, WF_ITEM_ATTRIBUTE_VALUES SUBMIT_ATTRIBUTE
, WF_PROCESS_ACTIVITIES ACTIVITY1
, WF_PROCESS_ACTIVITIES ACTIVITY2
, HR_API_TRANSACTION_STEPS STEP
, HR_API_TRANSACTION_VALUES VLV
, HR_API_TRANSACTION_VALUES VLV1
, HR_API_TRANSACTION_VALUES VLV2
, HR_API_TRANSACTION_VALUES VLV3
, HR_API_TRANSACTION_VALUES VLV4
, HR_API_TRANSACTION_VALUES VLV5
, HR_API_TRANSACTION_VALUES VLV6
, HR_API_TRANSACTION_VALUES VLV7
, HR_API_TRANSACTION_VALUES VLV8
, HR_API_TRANSACTION_VALUES VLV9
, HR_API_TRANSACTION_VALUES VLV10
, HR_API_TRANSACTION_VALUES VLV11
, HR_API_TRANSACTION_VALUES VLV12
, HR_API_TRANSACTION_VALUES VLV13
, HR_API_TRANSACTION_VALUES VLV14
WHERE VLV.NUMBER_VALUE IS NOT NULL
AND SUBMIT_ATTRIBUTE.TEXT_VALUE = 'Y'
AND ACTIVITY1.ACTIVITY_NAME = 'HR_COMP_UPDATE_PRC'
AND ACTIVITY1.PROCESS_ITEM_TYPE = 'HRSSA'
AND ACTIVITY1.ACTIVITY_ITEM_TYPE = 'HRSSA'
AND ACTIVITY1.PROCESS_NAME = ACTIVITY2.ACTIVITY_NAME
AND ACTIVITY2.PROCESS_NAME = 'ROOT'
AND ACTIVITY2.PROCESS_ITEM_TYPE = 'HRSSA'
AND ACTIVITY2.ACTIVITY_ITEM_TYPE = 'HRSSA'
AND ACTIVITY2.INSTANCE_ID = PROCESS.PROCESS_ACTIVITY
AND PROCESS.ACTIVITY_STATUS = 'ACTIVE'
AND PROCESS.ITEM_TYPE = 'HRSSA'
AND ACTIVITY1.INSTANCE_ID = PROCESS2.PROCESS_ACTIVITY
AND PROCESS2.ITEM_KEY = PROCESS.ITEM_KEY
AND PROCESS2.ITEM_TYPE = 'HRSSA'
AND SUBMIT_ATTRIBUTE.ITEM_KEY = PROCESS.ITEM_KEY
AND SUBMIT_ATTRIBUTE.ITEM_TYPE = PROCESS.ITEM_TYPE
AND SUBMIT_ATTRIBUTE.NAME = 'TRAN_SUBMIT'
AND STEP.ITEM_TYPE = 'HRSSA'
AND SUBMIT_ATTRIBUTE.ITEM_KEY = STEP.ITEM_KEY
AND STEP.API_NAME = 'BEN_PROCESS_COMPENSATION_W.PROCESS_API'
AND STEP.TRANSACTION_STEP_ID = VLV.TRANSACTION_STEP_ID
AND VLV.NAME = 'P_PERSON_ID'
AND STEP.TRANSACTION_STEP_ID = VLV1.TRANSACTION_STEP_ID (+)
AND VLV1.NAME (+) = 'P_ELIG_PER_ELCTBL_CHC_ID'
AND STEP.TRANSACTION_STEP_ID = VLV2.TRANSACTION_STEP_ID (+)
AND VLV2.NAME (+) = 'P_BNFT_AMT'
AND STEP.TRANSACTION_STEP_ID = VLV3.TRANSACTION_STEP_ID (+)
AND VLV3.NAME (+) = 'P_RT_VAL'
AND STEP.TRANSACTION_STEP_ID = VLV4.TRANSACTION_STEP_ID (+)
AND VLV4.NAME (+) = 'P_PL_NAME'
AND STEP.TRANSACTION_STEP_ID = VLV5.TRANSACTION_STEP_ID (+)
AND VLV5.NAME (+) = 'P_ENRT_CVG_STRT_DT'
AND STEP.TRANSACTION_STEP_ID = VLV6.TRANSACTION_STEP_ID (+)
AND VLV6.NAME (+) = 'P_RT_STRT_DT'
AND STEP.TRANSACTION_STEP_ID = VLV7.TRANSACTION_STEP_ID (+)
AND VLV7.NAME (+) = 'P_RT_END_DT'
AND STEP.TRANSACTION_STEP_ID = VLV8.TRANSACTION_STEP_ID (+)
AND VLV8.NAME (+) = 'P_LIMIT_RT_VAL'
AND STEP.TRANSACTION_STEP_ID = VLV9.TRANSACTION_STEP_ID (+)
AND VLV9.NAME (+) = 'P_JUSTIFICATION'
AND STEP.TRANSACTION_STEP_ID = VLV10.TRANSACTION_STEP_ID (+)
AND VLV10.NAME (+) = 'P_FREQUENCY_MEANING'
AND STEP.TRANSACTION_STEP_ID = VLV11.TRANSACTION_STEP_ID (+)
AND VLV11.NAME (+) = 'P_RT_UOM'
AND STEP.TRANSACTION_STEP_ID = VLV12.TRANSACTION_STEP_ID (+)
AND VLV12.NAME (+) = 'P_BNFT_UOM'
AND STEP.TRANSACTION_STEP_ID = VLV13.TRANSACTION_STEP_ID (+)
AND VLV13.NAME (+) = 'P_ACTY_REF_PERD_CD'
AND STEP.TRANSACTION_STEP_ID = VLV14.TRANSACTION_STEP_ID (+)
AND VLV14.NAME (+) = 'P_BNFT_TYP_MEANING'

Columns