DBA Data[Home] [Help]

APPS.PAY_NL_REM_REPORT dependencies on PAY_RUN_RESULTS

Line 509: pay_run_results prr,

505: CURSOR cur_get_deleted_zvw_entry(p_input_value IN NUMBER) IS
506: SELECT
507: NVL(fnd_number.canonical_to_number(prrv.result_value),0)
508: FROM
509: pay_run_results prr,
510: pay_run_result_values prrv,
511: pay_element_entries_f pee
512: WHERE prr.assignment_action_id = assact_id
513: AND prr.run_result_id = prrv.run_result_id

Line 1170: ,pay_run_results prr

1166: ,paa.assignment_id asg_id
1167: ,concat(concat('R '||ptp.period_num,' '),TO_CHAR(ptp.START_DATE,'YYYY')) period_name
1168: FROM pay_payroll_actions ppa
1169: ,pay_assignment_actions paa
1170: ,pay_run_results prr
1171: ,per_time_periods ptp
1172: WHERE paa.payroll_action_id = ppa.payroll_action_id
1173: AND paa.source_action_id IS NOT NULL
1174: AND paa.action_status IN ('C','S')