VIEW: APPS.BEN_PNDG_WRKFLW_APPRVLS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'