VIEW: APPS.PAY_JP_SOE_PREPAY_RESULTS_V

Source

View Text - Preformatted

SELECT paa.assignment_action_id, nvl(pettl.reporting_name,pettl.element_name), pbf.scale, prr.run_result_id, nvl(to_number(prrv.result_value),0) from pay_element_types_f_tl pettl, pay_balance_types pbt, pay_balance_feeds_f pbf, pay_run_result_values prrv, pay_run_results prr, pay_payroll_actions ppa2, pay_assignment_actions paa2, pay_action_interlocks pai, pay_assignment_actions paa where pai.locking_action_id=paa.assignment_action_id and paa2.assignment_action_id=pai.locked_action_id and ppa2.payroll_action_id=paa2.payroll_action_id and prr.assignment_action_id=paa2.assignment_action_id and prr.status in ('P','PA') and prrv.run_result_id=prr.run_result_id and pbf.input_value_id=prrv.input_value_id and ppa2.effective_date between pbf.effective_start_date and pbf.effective_end_date and pbt.balance_type_id=pbf.balance_type_id and pbt.assignment_remuneration_flag='Y' and pettl.element_type_id=prr.element_type_id and pettl.language=userenv('LANG')

View Text - HTML Formatted

SELECT PAA.ASSIGNMENT_ACTION_ID
, NVL(PETTL.REPORTING_NAME
, PETTL.ELEMENT_NAME)
, PBF.SCALE
, PRR.RUN_RESULT_ID
, NVL(TO_NUMBER(PRRV.RESULT_VALUE)
, 0)
FROM PAY_ELEMENT_TYPES_F_TL PETTL
, PAY_BALANCE_TYPES PBT
, PAY_BALANCE_FEEDS_F PBF
, PAY_RUN_RESULT_VALUES PRRV
, PAY_RUN_RESULTS PRR
, PAY_PAYROLL_ACTIONS PPA2
, PAY_ASSIGNMENT_ACTIONS PAA2
, PAY_ACTION_INTERLOCKS PAI
, PAY_ASSIGNMENT_ACTIONS PAA
WHERE PAI.LOCKING_ACTION_ID=PAA.ASSIGNMENT_ACTION_ID
AND PAA2.ASSIGNMENT_ACTION_ID=PAI.LOCKED_ACTION_ID
AND PPA2.PAYROLL_ACTION_ID=PAA2.PAYROLL_ACTION_ID
AND PRR.ASSIGNMENT_ACTION_ID=PAA2.ASSIGNMENT_ACTION_ID
AND PRR.STATUS IN ('P'
, 'PA')
AND PRRV.RUN_RESULT_ID=PRR.RUN_RESULT_ID
AND PBF.INPUT_VALUE_ID=PRRV.INPUT_VALUE_ID
AND PPA2.EFFECTIVE_DATE BETWEEN PBF.EFFECTIVE_START_DATE
AND PBF.EFFECTIVE_END_DATE
AND PBT.BALANCE_TYPE_ID=PBF.BALANCE_TYPE_ID
AND PBT.ASSIGNMENT_REMUNERATION_FLAG='Y'
AND PETTL.ELEMENT_TYPE_ID=PRR.ELEMENT_TYPE_ID
AND PETTL.LANGUAGE=USERENV('LANG')