APPS.PAY_AU_PAYE_FF dependencies on PAY_RUN_RESULT_VALUES

Line 2062: pay_run_result_values prrv,

2058: select 'Y'
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,

Line 2318: pay_run_result_values prv,

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
2322: and prv.run_result_id = prr.run_result_id

Line 2503: pay_run_result_values prv,

2499: cursor get_period_spread_over is
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

Line 2524: pay_run_result_values prv,

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
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

Line 2538: pay_run_result_values prv,

2534: cursor get_retro_spread_earning is
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

Line 2625: pay_run_result_values prv,

2621: cursor get_retro_spread_earning is
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