DBA Data[Home] [Help]

APPS.PAY_MIX_ROLLBACK_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 109: pay_element_links_f pel,

105: cursor c_batch_entries (c_assignment_id number) is
106: select pee.element_entry_id, pee.creator_type,
107: pee.creator_id, pee.effective_start_date
108: from pay_element_entries_f pee,
109: pay_element_links_f pel,
110: pay_element_types_f pet
111: where pee.creator_id = p_batch_header_id
112: and pee.creator_type = 'H'
113: and (pee.source_id is null or pee.source_id = p_asg_action_id)

Line 133: pay_element_links_f pel,

129: select pee.element_entry_id, pee.creator_type,
130: pee.creator_id, pee.effective_start_date
131: from per_absence_attendances paa,
132: pay_element_entries_f pee,
133: pay_element_links_f pel,
134: pay_element_types_f pet
135: where paa.batch_id = p_batch_header_id
136: and pee.creator_id = paa.absence_attendance_id
137: and pee.creator_type = 'A'

Line 152: pay_element_links_f pel,

148: union all
149: select pee.element_entry_id, pee.creator_type,
150: pee.creator_id, pee.effective_start_date
151: from pay_element_entries_f pee,
152: pay_element_links_f pel,
153: pay_element_types_f pet
154: where pee.creator_id = p_batch_header_id
155: and pee.creator_type = 'H'
156: and (pee.source_id is null or pee.source_id = p_asg_action_id)