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 6762: ,pay_element_links_f el

6758: , iv1.name
6759: FROM per_all_assignments_f asg1
6760: ,per_all_assignments_f asg2
6761: ,per_all_people_f per
6762: ,pay_element_links_f el
6763: ,pay_element_types_f et
6764: ,pay_input_values_f iv1
6765: ,pay_element_entries_f ee
6766: ,pay_element_entry_values_f eev1

Line 7056: ,pay_element_links_f el

7052: , iv1.name
7053: FROM per_all_assignments_f asg1
7054: ,per_all_assignments_f asg2
7055: ,per_all_people_f per
7056: ,pay_element_links_f el
7057: ,pay_element_types_f et
7058: ,pay_input_values_f iv1
7059: ,pay_element_entries_f ee
7060: ,pay_element_entry_values_f eev1

Line 7111: ,pay_element_links_f el

7107: BEGIN
7108: SELECT MAX(ee.effective_end_date)
7109: INTO l_max_date
7110: FROM pay_element_types_f et
7111: ,pay_element_links_f el
7112: ,pay_input_values_f iv1
7113: ,pay_element_entries_f ee
7114: ,pay_element_entry_values_f eev1
7115: WHERE et.element_name = 'Sickness Unpaid'

Line 7222: ,pay_element_links_f el

7218: , iv1.name
7219: FROM per_all_assignments_f asg1
7220: ,per_all_assignments_f asg2
7221: ,per_all_people_f per
7222: ,pay_element_links_f el
7223: ,pay_element_types_f et
7224: ,pay_input_values_f iv1
7225: ,pay_element_entries_f ee
7226: ,pay_element_entry_values_f eev1

Line 7296: ,pay_element_links_f el

7292: BEGIN
7293: SELECT MAX(ee.effective_end_date)
7294: INTO l_max_date
7295: FROM pay_element_types_f et
7296: ,pay_element_links_f el
7297: ,pay_input_values_f iv1
7298: ,pay_element_entries_f ee
7299: ,pay_element_entry_values_f eev1
7300: WHERE et.element_name = 'Sickness Unpaid'