DBA Data[Home] [Help]

APPS.PAY_FI_RULES dependencies on PAY_ELEMENT_ENTRIES_F

Line 81: pay_element_entries_f pee

77:
78: CURSOR get_element_name(p_ee_id NUMBER , p_effective_date DATE ) IS
79: SELECT pet.element_name
80: FROM pay_element_types_f pet,
81: pay_element_entries_f pee
82: WHERE pee.element_entry_id = p_ee_id
83: AND pee.element_type_id = pet.element_type_id
84: AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date
85: AND p_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date;

Line 96: ,pay_element_entries_F ee

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: ,pay_assignment_actions pac
99: ,pay_payroll_actions ppa
100: WHERE per.person_id = asg1.person_id

Line 368: ,pay_element_entries_f ee

364: FROM per_all_assignments_f asg1
365: ,pay_element_links_f el
366: ,pay_element_types_f et
367: ,pay_input_values_f iv1
368: ,pay_element_entries_f ee
369: ,pay_element_entry_values_f eev1
370: ,pay_assignment_actions pac
371: ,pay_payroll_actions ppa
372: WHERE pac.assignment_action_id = P_ASG_ACT_ID