VIEW: APPS.PAY_PAYMENT_ACTIONS_V

Source

View Text - Preformatted

SELECT paa_pp.assignment_action_id , paa_pp.assignment_id , paa_pp.payroll_action_id , paa_pp.action_status , paa_pp.chunk_number , paa_pp.action_sequence , paa_pp.pre_payment_id , paa_pp.serial_number , paa_pp.object_version_number , paa_pp.tax_unit_id , paa_pp.source_action_id , paa_pp.run_type_id , paa_run.assignment_action_id , paa_run.assignment_id , paa_run.payroll_action_id , paa_run.action_status , paa_run.chunk_number , paa_run.action_sequence , paa_run.pre_payment_id , paa_run.serial_number , paa_run.object_version_number , paa_run.tax_unit_id , paa_run.source_action_id , paa_run.run_type_id , ppa_run.run_type_id , prt.run_method , ppa_run.effective_date , ppa_run.date_earned , ppa_run.payroll_id , ppp.pre_payment_id , ppp.personal_payment_method_id , ppp.org_payment_method_id , ppp.value , ppp.base_currency_value , ppp.source_action_id , nvl(ppp.source_action_id, nvl(paa_run.source_action_id , paa_run.assignment_action_id)) , decode (nvl (paa_run.source_action_id, -999), -999, decode(nvl(ppa_run.run_type_id, -999), -999, 'N', 'Y'), 'N') FROM PAY_PRE_PAYMENTS PPP,PAY_ASSIGNMENT_ACTIONS PAA_PP,PAY_ACTION_INTERLOCKS PAI,PAY_ASSIGNMENT_ACTIONS PAA_RUN,PAY_PAYROLL_ACTIONS PPA_RUN,PAY_RUN_TYPES_F PRT where ppp.assignment_action_id = paa_pp.assignment_action_id and pai.locking_action_id = paa_pp.assignment_action_id and pai.locked_action_id = paa_run.assignment_action_id and paa_run.run_type_id = prt.run_type_id (+) and paa_run.payroll_action_id = ppa_run.payroll_action_id and ppa_run.effective_date between nvl(prt.effective_start_date, ppa_run.effective_date) and nvl(prt.effective_end_date, ppa_run.effective_date) and paa_run.assignment_action_id = decode (nvl(ppp.source_action_id, -999), -999, decode (nvl(prt.run_method, 'N'), 'S', -999, paa_run.assignment_action_id), ppp.source_action_id)

View Text - HTML Formatted

SELECT PAA_PP.ASSIGNMENT_ACTION_ID
, PAA_PP.ASSIGNMENT_ID
, PAA_PP.PAYROLL_ACTION_ID
, PAA_PP.ACTION_STATUS
, PAA_PP.CHUNK_NUMBER
, PAA_PP.ACTION_SEQUENCE
, PAA_PP.PRE_PAYMENT_ID
, PAA_PP.SERIAL_NUMBER
, PAA_PP.OBJECT_VERSION_NUMBER
, PAA_PP.TAX_UNIT_ID
, PAA_PP.SOURCE_ACTION_ID
, PAA_PP.RUN_TYPE_ID
, PAA_RUN.ASSIGNMENT_ACTION_ID
, PAA_RUN.ASSIGNMENT_ID
, PAA_RUN.PAYROLL_ACTION_ID
, PAA_RUN.ACTION_STATUS
, PAA_RUN.CHUNK_NUMBER
, PAA_RUN.ACTION_SEQUENCE
, PAA_RUN.PRE_PAYMENT_ID
, PAA_RUN.SERIAL_NUMBER
, PAA_RUN.OBJECT_VERSION_NUMBER
, PAA_RUN.TAX_UNIT_ID
, PAA_RUN.SOURCE_ACTION_ID
, PAA_RUN.RUN_TYPE_ID
, PPA_RUN.RUN_TYPE_ID
, PRT.RUN_METHOD
, PPA_RUN.EFFECTIVE_DATE
, PPA_RUN.DATE_EARNED
, PPA_RUN.PAYROLL_ID
, PPP.PRE_PAYMENT_ID
, PPP.PERSONAL_PAYMENT_METHOD_ID
, PPP.ORG_PAYMENT_METHOD_ID
, PPP.VALUE
, PPP.BASE_CURRENCY_VALUE
, PPP.SOURCE_ACTION_ID
, NVL(PPP.SOURCE_ACTION_ID
, NVL(PAA_RUN.SOURCE_ACTION_ID
, PAA_RUN.ASSIGNMENT_ACTION_ID))
, DECODE (NVL (PAA_RUN.SOURCE_ACTION_ID
, -999)
, -999
, DECODE(NVL(PPA_RUN.RUN_TYPE_ID
, -999)
, -999
, 'N'
, 'Y')
, 'N')
FROM PAY_PRE_PAYMENTS PPP
, PAY_ASSIGNMENT_ACTIONS PAA_PP
, PAY_ACTION_INTERLOCKS PAI
, PAY_ASSIGNMENT_ACTIONS PAA_RUN
, PAY_PAYROLL_ACTIONS PPA_RUN
, PAY_RUN_TYPES_F PRT
WHERE PPP.ASSIGNMENT_ACTION_ID = PAA_PP.ASSIGNMENT_ACTION_ID
AND PAI.LOCKING_ACTION_ID = PAA_PP.ASSIGNMENT_ACTION_ID
AND PAI.LOCKED_ACTION_ID = PAA_RUN.ASSIGNMENT_ACTION_ID
AND PAA_RUN.RUN_TYPE_ID = PRT.RUN_TYPE_ID (+)
AND PAA_RUN.PAYROLL_ACTION_ID = PPA_RUN.PAYROLL_ACTION_ID
AND PPA_RUN.EFFECTIVE_DATE BETWEEN NVL(PRT.EFFECTIVE_START_DATE
, PPA_RUN.EFFECTIVE_DATE)
AND NVL(PRT.EFFECTIVE_END_DATE
, PPA_RUN.EFFECTIVE_DATE)
AND PAA_RUN.ASSIGNMENT_ACTION_ID = DECODE (NVL(PPP.SOURCE_ACTION_ID
, -999)
, -999
, DECODE (NVL(PRT.RUN_METHOD
, 'N')
, 'S'
, -999
, PAA_RUN.ASSIGNMENT_ACTION_ID)
, PPP.SOURCE_ACTION_ID)