DBA Data[Home] [Help]

APPS.PAY_NO_ABSENCE dependencies on PAY_ELEMENT_LINKS_F

Line 93: ,pay_element_links_f el

89: SELECT eev1.screen_entry_value screen_entry_value
90: FROM per_all_assignments_f asg1
91: ,per_all_assignments_f asg2
92: ,per_all_people_f per
93: ,pay_element_links_f el
94: ,pay_element_types_f et
95: ,pay_input_values_f iv1
96: ,pay_element_entries_f ee
97: ,pay_element_entry_values_f eev1

Line 6662: ,pay_element_links_f el

6658: , iv1.name
6659: FROM per_all_assignments_f asg1
6660: ,per_all_assignments_f asg2
6661: ,per_all_people_f per
6662: ,pay_element_links_f el
6663: ,pay_element_types_f et
6664: ,pay_input_values_f iv1
6665: ,pay_element_entries_f ee
6666: ,pay_element_entry_values_f eev1

Line 6956: ,pay_element_links_f el

6952: , iv1.name
6953: FROM per_all_assignments_f asg1
6954: ,per_all_assignments_f asg2
6955: ,per_all_people_f per
6956: ,pay_element_links_f el
6957: ,pay_element_types_f et
6958: ,pay_input_values_f iv1
6959: ,pay_element_entries_f ee
6960: ,pay_element_entry_values_f eev1

Line 7011: ,pay_element_links_f el

7007: BEGIN
7008: SELECT MAX(ee.effective_end_date)
7009: INTO l_max_date
7010: FROM pay_element_types_f et
7011: ,pay_element_links_f el
7012: ,pay_input_values_f iv1
7013: ,pay_element_entries_f ee
7014: ,pay_element_entry_values_f eev1
7015: WHERE et.element_name = 'Sickness Unpaid'

Line 7122: ,pay_element_links_f el

7118: , iv1.name
7119: FROM per_all_assignments_f asg1
7120: ,per_all_assignments_f asg2
7121: ,per_all_people_f per
7122: ,pay_element_links_f el
7123: ,pay_element_types_f et
7124: ,pay_input_values_f iv1
7125: ,pay_element_entries_f ee
7126: ,pay_element_entry_values_f eev1

Line 7196: ,pay_element_links_f el

7192: BEGIN
7193: SELECT MAX(ee.effective_end_date)
7194: INTO l_max_date
7195: FROM pay_element_types_f et
7196: ,pay_element_links_f el
7197: ,pay_input_values_f iv1
7198: ,pay_element_entries_f ee
7199: ,pay_element_entry_values_f eev1
7200: WHERE et.element_name = 'Sickness Unpaid'