APPS.PAY_NO_ABSENCE dependencies on PAY_ELEMENT_TYPES_F

Line 94: ,pay_element_types_f et

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
98: WHERE asg1.assignment_id = l_asg_id

Line 121: FROM pay_element_types_f pet

117: AND eev1.effective_end_date = l_end_dt ;
118:
119: CURSOR CSR_RUN_RESULT_FETCH (p_input_name varchar2, stdate date, enddate date) IS
120: SELECT result_value
121: FROM pay_element_types_f pet
122: , pay_element_entries_f pee
123: , pay_run_results prr
124: , pay_run_result_values prrv
125: , pay_input_values_f piv

Line 6763: ,pay_element_types_f et

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
6767: WHERE asg1.assignment_id = p_assignment_id

Line 7057: ,pay_element_types_f et

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
7061: WHERE asg1.assignment_id = p_assignment_id

Line 7110: FROM pay_element_types_f et

7106:
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

Line 7223: ,pay_element_types_f et

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
7227: WHERE asg1.assignment_id = p_assignment_id

Line 7295: FROM pay_element_types_f et

7291:
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