APPS.PAY_MIX_ROLLBACK_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 108: from pay_element_entries_f pee,

104:
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'

Line 132: pay_element_entries_f pee,

128: union all
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

Line 151: from pay_element_entries_f pee,

147: and l_ele_class_chk is null
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'

Line 173: from pay_element_entries_f pee

169: and l_ele_class_chk is not null
170: union all
171: select pee.element_entry_id, pee.creator_type,
172: pee.creator_id, pee.effective_start_date
173: from pay_element_entries_f pee
174: where pee.creator_id = p_batch_header_id
175: and pee.creator_type = 'H'
176: and pee.source_id = p_asg_action_id
177: and pee.assignment_id = c_assignment_id

Line 184: pay_element_entries_f pee

180: union all
181: select pee.element_entry_id, pee.creator_type,
182: pee.creator_id, pee.effective_start_date
183: from per_absence_attendances paa,
184: pay_element_entries_f pee
185: where paa.batch_id = p_batch_header_id
186: and pee.creator_id = paa.absence_attendance_id
187: and pee.creator_type = 'A'
188: and pee.source_id = p_asg_action_id

Line 218: from pay_element_entries_f pee

214: and pact.batch_process_mode = 'TRANSFER';
215:
216: cursor csr_check_entry_modified (p_ee_id number, p_eff_date date) is
217: select 'Y'
218: from pay_element_entries_f pee
219: where pee.element_entry_id = p_ee_id
220: and p_eff_date between pee.effective_start_date
221: and pee.effective_end_date
222: and pee.creator_type in ('A','H')

Line 225: from pay_element_entries_f pee1

221: and pee.effective_end_date
222: and pee.creator_type in ('A','H')
223: and pee.creator_id is not null
224: and exists (select null
225: from pay_element_entries_f pee1
226: where pee.element_entry_id = pee1.element_entry_id
227: and (pee1.creator_type <> pee.creator_type
228: or pee1.creator_id <> pee.creator_id));
229:

Line 887: pay_element_entries_f pee

883: select 'Y' into l_results_found
884: from pay_run_results prr,
885: pay_assignment_actions paa,
886: pay_payroll_actions ppa,
887: pay_element_entries_f pee
888: where prr.source_type = 'E'
889: and pee.element_entry_id = p_element_entry_id
890: and p_effective_session_date between pee.effective_start_date
891: and pee.effective_end_date