DBA Data[Home] [Help]

APPS.PAY_FR_GENERAL dependencies on PAY_INPUT_VALUES_F

Line 143: , pay_input_values_f piv

139: cursor pay_run_result_csr is
140: select prrv.result_value
141: from pay_run_results prr
142: , pay_element_types_f pet
143: , pay_input_values_f piv
144: , pay_run_result_values prrv
145: where prr.assignment_action_id = g_prior_asg_action_id
146: and prr.element_type_id = pet.element_type_id
147: and pet.ELEMENT_NAME = p_element_name

Line 1259: , pay_input_values_f piv

1255: cursor first_sickness_abs_csr is
1256: select min(paa.date_start)
1257: from pay_balance_types pbt
1258: , pay_balance_feeds_f pbf
1259: , pay_input_values_f piv
1260: , pay_element_types_f pet
1261: , pay_element_entries_f pee
1262: , pay_element_links_f pel
1263: , per_absence_attendances paa

Line 1320: , pay_input_values_f piv

1316: select /*+ USE_NL(pbt pee pee2) */
1317: sum(paa.absence_days)
1318: from pay_balance_types pbt
1319: , pay_balance_feeds_f pbf
1320: , pay_input_values_f piv
1321: , pay_element_types_f pet
1322: , pay_element_entries_f pee
1323: , pay_element_links_f pel
1324: , per_absence_attendances paa