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 6663: ,pay_element_types_f et

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

Line 6957: ,pay_element_types_f et

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

Line 7010: FROM pay_element_types_f et

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

Line 7123: ,pay_element_types_f et

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

Line 7195: FROM pay_element_types_f et

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