APPS.BEN_ELEMENT_ENTRY dependencies on PAY_RUN_RESULTS

Line 195: from pay_run_results h

191: (c_assignment_action_id in number
192: ,c_element_type_id in number
193: ) is
194: select 'x'
195: from pay_run_results h
196: where h.element_type_id = c_element_type_id
197: and h.assignment_action_id = c_assignment_action_id
198: and h.status in ('P', 'PA')
199: and h.source_type = 'E';

Line 266: from pay_run_results prr,

262: -- Define how to determine if the entry is processed
263: --
264: cursor nonrecurring_entries (adjust_ee_source in varchar2) is
265: select 'Y'
266: from pay_run_results prr,
267: pay_element_entries_f pee
268: where pee.element_entry_id = p_element_entry_id
269: and p_effective_date between pee.effective_start_date
270: and pee.effective_end_date

Line 284: from pay_run_results sub_rr

280: and prr.source_type = 'E'
281: and prr.status <> 'U'
282: and not exists
283: (select 1
284: from pay_run_results sub_rr
285: where sub_rr.source_id = prr.run_result_id
286: and sub_rr.source_type in ('R', 'V')) ;
287: --
288: -- Bug 522510, recurring entries are considered as processed in the Date Earned

Line 294: from pay_run_results result,

290: --
291:
292: cursor recurring_entries is
293: select 'Y'
294: from pay_run_results result,
295: pay_assignment_actions asgt_action,
296: pay_payroll_actions pay_action,
297: per_time_periods period
298: where result.source_id = nvl (p_original_entry_id, p_element_entry_id)

Line 308: from pay_run_results rev_result

304: and pay_action.date_earned between period.start_date
305: and period.end_date
306: and not exists
307: (select 1
308: from pay_run_results rev_result
309: where rev_result.source_id = result.run_result_id
310: and rev_result.source_type in ('R', 'V'));
311: --
312: l_proc varchar2(72) := g_package||'chk_ele_processed';