APPS.HR_US_FF_UDF1 dependencies on PAY_INPUT_VALUES_F

Line 1324: pay_input_values_f piv1,

1320: pay_element_entry_values_f pev2,
1321: pay_element_entries_f pee,
1322: pay_element_links_f pel,
1323: pay_element_types_f pet,
1324: pay_input_values_f piv1,
1325: pay_input_values_f piv2
1326: where pee.assignment_id = l_assignment_id
1327: -- and l_date_paid between pee.effective_start_date
1328: and l_date_earned between pee.effective_start_date

Line 1325: pay_input_values_f piv2

1321: pay_element_entries_f pee,
1322: pay_element_links_f pel,
1323: pay_element_types_f pet,
1324: pay_input_values_f piv1,
1325: pay_input_values_f piv2
1326: where pee.assignment_id = l_assignment_id
1327: -- and l_date_paid between pee.effective_start_date
1328: and l_date_earned between pee.effective_start_date
1329: and pee.effective_end_date

Line 1360: ,pay_input_values_f piv

1356: from pay_element_classifications pec
1357: ,pay_element_types_f pet
1358: ,pay_element_entries_f pee
1359: ,pay_element_links_f pel
1360: ,pay_input_values_f piv
1361: ,pay_element_entry_values_f peev
1362: where pec.classification_name in
1363: ( 'Earnings', 'Supplemental Earnings','Imputed Earnings' )
1364: and pet.classification_id = pec.classification_id

Line 2487: pay_input_values_f piv1,

2483: pay_element_entry_values_f pev2,
2484: pay_element_entries_f pee,
2485: pay_element_links_f pel,
2486: pay_element_types_f pet,
2487: pay_input_values_f piv1,
2488: pay_input_values_f piv2,
2489: pay_element_type_extra_info extra
2490: WHERE extra.information_type = 'PAY_US_INFORMATION_TIME'
2491: AND extra.eei_information1 = 'Y'

Line 2488: pay_input_values_f piv2,

2484: pay_element_entries_f pee,
2485: pay_element_links_f pel,
2486: pay_element_types_f pet,
2487: pay_input_values_f piv1,
2488: pay_input_values_f piv2,
2489: pay_element_type_extra_info extra
2490: WHERE extra.information_type = 'PAY_US_INFORMATION_TIME'
2491: AND extra.eei_information1 = 'Y'
2492: AND extra.element_type_id = pet.element_type_id

Line 2603: pay_input_values_f piv1,

2599: pay_element_entry_values_f pev2,
2600: pay_element_entries_f pee,
2601: pay_element_links_f pel,
2602: pay_element_types_f pet,
2603: pay_input_values_f piv1,
2604: pay_input_values_f piv2,
2605: pay_element_classifications pec
2606: WHERE pec.classification_name IN ( 'Earnings', 'Supplemental Earnings','Imputed Earnings' )
2607: AND pec.legislation_code = 'US'

Line 2604: pay_input_values_f piv2,

2600: pay_element_entries_f pee,
2601: pay_element_links_f pel,
2602: pay_element_types_f pet,
2603: pay_input_values_f piv1,
2604: pay_input_values_f piv2,
2605: pay_element_classifications pec
2606: WHERE pec.classification_name IN ( 'Earnings', 'Supplemental Earnings','Imputed Earnings' )
2607: AND pec.legislation_code = 'US'
2608: AND pec.classification_id = pet.classification_id

Line 2651: ,pay_input_values_f piv

2647: FROM pay_element_classifications pec
2648: ,pay_element_types_f pet
2649: ,pay_element_entries_f pee
2650: ,pay_element_links_f pel
2651: ,pay_input_values_f piv
2652: ,pay_element_entry_values_f peev
2653: WHERE pec.classification_name in
2654: ( 'Earnings', 'Supplemental Earnings','Imputed Earnings' )
2655: AND pec.legislation_code = 'US'

Line 5195: pay_input_values_f piv1,

5191: pay_element_entry_values_f pev2,
5192: pay_element_entries_f pee,
5193: pay_element_links_f pel,
5194: pay_element_types_f pet,
5195: pay_input_values_f piv1,
5196: pay_input_values_f piv2,
5197: pay_element_type_extra_info extra,
5198: per_assignments_f paf
5199: WHERE extra.information_type = 'PAY_US_INFORMATION_TIME'

Line 5196: pay_input_values_f piv2,

5192: pay_element_entries_f pee,
5193: pay_element_links_f pel,
5194: pay_element_types_f pet,
5195: pay_input_values_f piv1,
5196: pay_input_values_f piv2,
5197: pay_element_type_extra_info extra,
5198: per_assignments_f paf
5199: WHERE extra.information_type = 'PAY_US_INFORMATION_TIME'
5200: AND extra.eei_information1 = 'Y'