APPS.HR_US_FF_UDF1 dependencies on PAY_INPUT_VALUES_F

Line 1365: pay_input_values_f piv1,

1361: pay_element_entry_values_f pev2,
1362: pay_element_entries_f pee,
1363: pay_element_links_f pel,
1364: pay_element_types_f pet,
1365: pay_input_values_f piv1,
1366: pay_input_values_f piv2
1367: where pee.assignment_id = l_assignment_id
1368: -- and l_date_paid between pee.effective_start_date
1369: and l_date_earned between pee.effective_start_date

Line 1366: pay_input_values_f piv2

1362: pay_element_entries_f pee,
1363: pay_element_links_f pel,
1364: pay_element_types_f pet,
1365: pay_input_values_f piv1,
1366: pay_input_values_f piv2
1367: where pee.assignment_id = l_assignment_id
1368: -- and l_date_paid between pee.effective_start_date
1369: and l_date_earned between pee.effective_start_date
1370: and pee.effective_end_date

Line 1401: ,pay_input_values_f piv

1397: from pay_element_classifications pec
1398: ,pay_element_types_f pet
1399: ,pay_element_entries_f pee
1400: ,pay_element_links_f pel
1401: ,pay_input_values_f piv
1402: ,pay_element_entry_values_f peev
1403: where pec.classification_name in
1404: ( 'Earnings', 'Supplemental Earnings','Imputed Earnings' )
1405: and pet.classification_id = pec.classification_id

Line 2586: pay_input_values_f piv1,

2582: pay_element_entry_values_f pev2,
2583: pay_element_entries_f pee,
2584: pay_element_links_f pel,
2585: pay_element_types_f pet,
2586: pay_input_values_f piv1,
2587: pay_input_values_f piv2,
2588: pay_element_type_extra_info extra
2589: WHERE extra.information_type = 'PAY_US_INFORMATION_TIME'
2590: AND extra.eei_information1 = 'Y'

Line 2587: pay_input_values_f piv2,

2583: pay_element_entries_f pee,
2584: pay_element_links_f pel,
2585: pay_element_types_f pet,
2586: pay_input_values_f piv1,
2587: pay_input_values_f piv2,
2588: pay_element_type_extra_info extra
2589: WHERE extra.information_type = 'PAY_US_INFORMATION_TIME'
2590: AND extra.eei_information1 = 'Y'
2591: AND extra.element_type_id = pet.element_type_id

Line 2702: pay_input_values_f piv1,

2698: pay_element_entry_values_f pev2,
2699: pay_element_entries_f pee,
2700: pay_element_links_f pel,
2701: pay_element_types_f pet,
2702: pay_input_values_f piv1,
2703: pay_input_values_f piv2,
2704: pay_element_classifications pec
2705: WHERE pec.classification_name IN ( 'Earnings', 'Supplemental Earnings','Imputed Earnings' )
2706: AND pec.legislation_code = 'US'

Line 2703: pay_input_values_f piv2,

2699: pay_element_entries_f pee,
2700: pay_element_links_f pel,
2701: pay_element_types_f pet,
2702: pay_input_values_f piv1,
2703: pay_input_values_f piv2,
2704: pay_element_classifications pec
2705: WHERE pec.classification_name IN ( 'Earnings', 'Supplemental Earnings','Imputed Earnings' )
2706: AND pec.legislation_code = 'US'
2707: AND pec.classification_id = pet.classification_id

Line 2750: ,pay_input_values_f piv

2746: FROM pay_element_classifications pec
2747: ,pay_element_types_f pet
2748: ,pay_element_entries_f pee
2749: ,pay_element_links_f pel
2750: ,pay_input_values_f piv
2751: ,pay_element_entry_values_f peev
2752: WHERE pec.classification_name in
2753: ( 'Earnings', 'Supplemental Earnings','Imputed Earnings' )
2754: AND pec.legislation_code = 'US'

Line 5382: pay_input_values_f piv1,

5378: pay_element_entry_values_f pev2,
5379: pay_element_entries_f pee,
5380: pay_element_links_f pel,
5381: pay_element_types_f pet,
5382: pay_input_values_f piv1,
5383: pay_input_values_f piv2,
5384: pay_element_type_extra_info extra,
5385: per_assignments_f paf
5386: WHERE extra.information_type = 'PAY_US_INFORMATION_TIME'

Line 5383: pay_input_values_f piv2,

5379: pay_element_entries_f pee,
5380: pay_element_links_f pel,
5381: pay_element_types_f pet,
5382: pay_input_values_f piv1,
5383: pay_input_values_f piv2,
5384: pay_element_type_extra_info extra,
5385: per_assignments_f paf
5386: WHERE extra.information_type = 'PAY_US_INFORMATION_TIME'
5387: AND extra.eei_information1 = 'Y'

Line 5954: pay_input_values_f piv1,

5950: pay_element_entry_values_f pev2,
5951: pay_element_entries_f pee,
5952: pay_element_links_f pel,
5953: pay_element_types_f pet,
5954: pay_input_values_f piv1,
5955: pay_input_values_f piv2
5956: where pee.assignment_id = p_assignment_id
5957: and pee.effective_start_date<=last_day(p_date_earned)
5958: and pee.effective_end_date>=trunc(p_date_earned,'MONTH')

Line 5955: pay_input_values_f piv2

5951: pay_element_entries_f pee,
5952: pay_element_links_f pel,
5953: pay_element_types_f pet,
5954: pay_input_values_f piv1,
5955: pay_input_values_f piv2
5956: where pee.assignment_id = p_assignment_id
5957: and pee.effective_start_date<=last_day(p_date_earned)
5958: and pee.effective_end_date>=trunc(p_date_earned,'MONTH')
5959: and pee.element_link_id = pel.element_link_id