APPS.PAY_NO_EOY_ARCHIVE dependencies on PAY_RUN_RESULT_VALUES

Line 2119: ,pay_run_result_values rrv

2115: ,pay_action_contexts ac2
2116: ,ff_contexts ctx2
2117: ,pay_payroll_actions ppa
2118: ,pay_run_results rr
2119: ,pay_run_result_values rrv
2120: ,pay_input_values_f pivf
2121: ,pay_user_tables t
2122: ,pay_user_rows_f r
2123: ,pay_element_entries_f pee

Line 2201: pay_run_result_values rrv,

2197: ,cde_info_dtl.action_information6 dtype
2198: from pay_run_results rr,
2199: pay_element_entries_f pee,
2200: pay_run_results rr1 ,
2201: pay_run_result_values rrv,
2202: -- pay_action_information cde_dtl,
2203: pay_action_information cde_info_dtl
2204: ,pay_element_type_extra_info eei
2205: ,pay_input_values_f pivf

Line 2295: ,pay_run_result_values rrv

2291: ,pay_action_contexts ac2
2292: ,ff_contexts ctx2
2293: ,pay_payroll_actions ppa
2294: ,pay_run_results rr
2295: ,pay_run_result_values rrv
2296: ,pay_input_values_f pivf
2297: ,pay_element_types_f petf
2298: ,pay_user_tables t
2299: ,pay_user_rows_f r

Line 2371: ,pay_run_result_values rrv

2367: ,pay_action_contexts ac2
2368: ,ff_contexts ctx2
2369: ,pay_payroll_actions ppa
2370: ,pay_run_results rr
2371: ,pay_run_result_values rrv
2372: ,pay_input_values_f pivf
2373: ,pay_element_types_f petf
2374: ,pay_user_tables t
2375: ,pay_user_rows_f r

Line 2422: FROM pay_run_result_values rrv

2418: ,sum(decode (piv.name,'Per Diem', fnd_number.canonical_to_number(rrv.result_value) ,0)) Per_Diem
2419: ,sum(decode (piv.name,'Number of Days to be reported', fnd_number.canonical_to_number(rrv.result_value) ,0)) Reporting_Days
2420: ,sum(decode (piv.name,'Number of Days', fnd_number.canonical_to_number(rrv.result_value) ,0)) Days
2421: ,max(decode (piv.name,'Country', rrv.result_value)) Country
2422: FROM pay_run_result_values rrv
2423: ,pay_input_values_f piv
2424: WHERE rrv.run_result_id = l_rr_id
2425: AND piv.element_type_id = l_element_type_id
2426: AND piv.name IN ('Pay Value','Number of Days','Per Diem','Number of Days to be reported','Country')