DBA Data[Home] [Help]

APPS.PQP_US_STUDENT_BEE dependencies on PAY_ELEMENT_ENTRIES_F

Line 72: From pay_element_entries_f pee

68: Select distinct
69: pel.element_type_id
70: ,pee.element_entry_id
71: ,pel.element_link_id
72: From pay_element_entries_f pee
73: ,pay_element_links_f pel
74: ,per_all_assignments_f paf
75: Where (c_end_date between pee.effective_start_date
76: and pee.effective_end_date

Line 136: from pay_element_entries_f pee

132: Cursor entry_date (c_element_entry_id in Number
133: ,c_assignment_id in Number) is
134: select max(pee.effective_start_date)
135: ,max(pee.effective_end_date)
136: from pay_element_entries_f pee
137: where pee.assignment_id = c_assignment_id
138: and pee.element_entry_id = c_element_entry_id;
139:
140: -- Define the record structure for holding the elements input names.