DBA Data[Home] [Help]

APPS.PAY_DK_SICKPAY_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 41: ,pay_element_links_f el

37: CURSOR csr_get_details(p_period_start_date DATE,p_period_end_date DATE,p_assignment_id NUMBER,p_input_value VARCHAR2) is
38: SELECT eev.screen_entry_value screen_entry_value
39: FROM per_all_assignments_f asg
40: ,per_all_people_f per
41: ,pay_element_links_f el
42: ,pay_element_types_f et
43: ,pay_input_values_f iv
44: ,pay_element_entries_f ee
45: ,pay_element_entry_values_f eev

Line 184: ,pay_element_links_f el

180: , iv1.name
181: FROM per_all_assignments_f asg1
182: ,per_all_assignments_f asg2
183: ,per_all_people_f per
184: ,pay_element_links_f el
185: ,pay_element_types_f et
186: ,pay_input_values_f iv1
187: ,pay_element_entries_f ee
188: ,pay_element_entry_values_f eev1

Line 400: ,pay_element_links_f el

396: CURSOR csr_get_details(p_period_start_date DATE,p_period_end_date DATE,p_assignment_id NUMBER,p_input_value VARCHAR2) is
397: SELECT eev.screen_entry_value screen_entry_value
398: FROM per_all_assignments_f asg
399: ,per_all_people_f per
400: ,pay_element_links_f el
401: ,pay_element_types_f et
402: ,pay_input_values_f iv
403: ,pay_element_entries_f ee
404: ,pay_element_entry_values_f eev