APPS.PAY_AU_PAYE_FF dependencies on PAY_RUN_RESULTS

Line 1240: pay_run_results prr,

1236: SELECT ptp.start_date,ptp.end_date
1237: FROM per_time_periods ptp,
1238: pay_payroll_actions ppa,
1239: pay_assignment_actions paa,
1240: pay_run_results prr,
1241: pay_element_entries_f pee
1242: WHERE pee.element_entry_id=c_element_entry_id
1243: and prr.run_result_id = pee.source_id
1244: and paa.assignment_action_id=prr.assignment_action_id

Line 1385: pay_run_results prr,

1381: ,ppa.effective_date
1382: FROM per_time_periods ptp,
1383: pay_payroll_actions ppa,
1384: pay_assignment_actions paa,
1385: pay_run_results prr,
1386: pay_element_entries_f pee
1387: WHERE pee.element_entry_id=c_element_entry_id
1388: AND prr.run_result_id = pee.source_id
1389: AND paa.assignment_action_id=prr.assignment_action_id

Line 2063: pay_run_results prr,

2059: from
2060: pay_element_types_f pet,
2061: pay_input_values_f piv,
2062: pay_run_result_values prrv,
2063: pay_run_results prr,
2064: pay_assignment_actions paa,
2065: pay_payroll_actions ppa,
2066: per_time_periods ptp,
2067: per_all_assignments_f paaf

Line 2317: from pay_run_results prr,

2313: l_procedure varchar2(80);
2314:
2315: CURSOR Cr_value IS (
2316: SELECT prv.result_value
2317: from pay_run_results prr,
2318: pay_run_result_values prv,
2319: pay_element_types_f pet,
2320: pay_input_values_f piv
2321: where prr.assignment_action_id = p_assignment_action_id

Line 2504: pay_run_results prr,

2500: select prv.RESULT_VALUE period_spread_over, prr.run_result_id, pee.creator_type
2501: from pay_element_types_f pet,
2502: pay_input_values_f piv,
2503: pay_run_result_values prv,
2504: pay_run_results prr,
2505: pay_element_entries_f pee
2506: where prr.assignment_action_id=p_assignment_action_id
2507: and prr.RUN_RESULT_ID = prv.RUN_RESULT_ID
2508: and prv.input_value_id = piv.input_value_id

Line 2521: cursor get_spread_earning(p_run_result_id pay_run_results.run_result_id%type) is

2517: and p_date_paid between pet.effective_start_date and pet.effective_end_date
2518: and p_date_paid between piv.effective_start_date and piv.effective_end_date
2519: and p_date_paid between pee.effective_start_date and pee.effective_end_date;
2520:
2521: cursor get_spread_earning(p_run_result_id pay_run_results.run_result_id%type) is
2522: select prv.RESULT_VALUE
2523: from pay_input_values_f piv,
2524: pay_run_result_values prv,
2525: pay_run_results prr

Line 2525: pay_run_results prr

2521: cursor get_spread_earning(p_run_result_id pay_run_results.run_result_id%type) is
2522: select prv.RESULT_VALUE
2523: from pay_input_values_f piv,
2524: pay_run_result_values prv,
2525: pay_run_results prr
2526: where prr.RUN_RESULT_ID = p_run_result_id
2527: and prr.RUN_RESULT_ID = prv.RUN_RESULT_ID
2528: and prv.input_value_id = piv.input_value_id
2529: and piv.name ='Total Payment'

Line 2539: pay_run_results prr,

2535: select nvl(sum(prv.RESULT_VALUE),0)
2536: from pay_element_types_f pet,
2537: pay_input_values_f piv,
2538: pay_run_result_values prv,
2539: pay_run_results prr,
2540: pay_element_entries_f pee
2541: where prr.assignment_action_id=p_assignment_action_id
2542: and prr.RUN_RESULT_ID = prv.RUN_RESULT_ID
2543: and prv.input_value_id = piv.input_value_id

Line 2626: pay_run_results prr,

2622: select nvl(sum(prv.RESULT_VALUE),0)
2623: from pay_element_types_f pet,
2624: pay_input_values_f piv,
2625: pay_run_result_values prv,
2626: pay_run_results prr,
2627: pay_element_entries_f pee
2628: where prr.assignment_action_id=p_assignment_action_id
2629: and prr.RUN_RESULT_ID = prv.RUN_RESULT_ID
2630: and prv.input_value_id = piv.input_value_id