DBA Data[Home] [Help]

APPS.PAY_NO_EOY_ARCHIVE dependencies on PAY_RUN_RESULT_VALUES

Line 1935: ,pay_run_result_values rrv

1931: ,pay_action_contexts ac2
1932: ,ff_contexts ctx2
1933: ,pay_payroll_actions ppa
1934: ,pay_run_results rr
1935: ,pay_run_result_values rrv
1936: ,pay_input_values_f pivf
1937: ,pay_user_tables t
1938: ,pay_user_rows_f r
1939: WHERE cde_dtl.action_context_type = 'PA'

Line 2051: ,pay_run_result_values rrv

2047: ,pay_action_contexts ac2
2048: ,ff_contexts ctx2
2049: ,pay_payroll_actions ppa
2050: ,pay_run_results rr
2051: ,pay_run_result_values rrv
2052: ,pay_input_values_f pivf
2053: ,pay_element_types_f petf
2054: ,pay_user_tables t
2055: ,pay_user_rows_f r

Line 2112: ,pay_run_result_values rrv

2108: ,pay_action_contexts ac2
2109: ,ff_contexts ctx2
2110: ,pay_payroll_actions ppa
2111: ,pay_run_results rr
2112: ,pay_run_result_values rrv
2113: ,pay_input_values_f pivf
2114: ,pay_element_types_f petf
2115: ,pay_user_tables t
2116: ,pay_user_rows_f r

Line 2163: FROM pay_run_result_values rrv

2159: ,sum(decode (piv.name,'Per Diem', fnd_number.canonical_to_number(rrv.result_value) ,0)) Per_Diem
2160: ,sum(decode (piv.name,'Number of Days to be reported', fnd_number.canonical_to_number(rrv.result_value) ,0)) Reporting_Days
2161: ,sum(decode (piv.name,'Number of Days', fnd_number.canonical_to_number(rrv.result_value) ,0)) Days
2162: ,max(decode (piv.name,'Country', rrv.result_value)) Country
2163: FROM pay_run_result_values rrv
2164: ,pay_input_values_f piv
2165: WHERE rrv.run_result_id = l_rr_id
2166: AND piv.element_type_id = l_element_type_id
2167: AND piv.name IN ('Pay Value','Number of Days','Per Diem','Number of Days to be reported','Country')