APPS.PAY_NO_EOY_ARCHIVE dependencies on PAY_INPUT_VALUES_F

Line 1936: ,pay_input_values_f pivf

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'
1940: AND cde_dtl.action_context_id = p_payroll_action_id

Line 2052: ,pay_input_values_f pivf

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
2056: WHERE ppa.business_group_id = p_business_group_id

Line 2113: ,pay_input_values_f pivf

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
2117: WHERE ppa.business_group_id = p_business_group_id

Line 2164: ,pay_input_values_f piv

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')
2168: AND piv.input_value_id = rrv.input_value_id