APPS.PAY_PAYWSMEE_PKG dependencies on PAY_RUN_RESULTS

Line 260: from pay_run_results prr,

256: -- Define how to determine if the entry is processed
257: --
258: cursor nonrecurring_entries (adjust_ee_source in varchar2) is
259: select 'Y'
260: from pay_run_results prr,
261: pay_element_entries_f pee
262: where pee.element_entry_id = p_element_entry_id
263: and p_effective_date between pee.effective_start_date
264: and pee.effective_end_date

Line 279: FROM PAY_RUN_RESULTS sub_rr

275: and prr.status <> 'U'
276: -- change 115.9
277: and NOT EXISTS
278: (SELECT 1
279: FROM PAY_RUN_RESULTS sub_rr
280: WHERE sub_rr.source_id = prr.run_result_id
281: and sub_rr.source_type in ('R', 'V'))
282: ;
283: --

Line 305: from pay_run_results RESULT,

301:
302: cursor recurring_entries is
303: --
304: select 'Y'
305: from pay_run_results RESULT,
306: pay_assignment_actions ASGT_ACTION,
307: pay_payroll_actions PAY_ACTION,
308: per_time_periods PERIOD
309: where result.source_id = nvl (p_original_entry_id, p_element_entry_id)

Line 320: FROM PAY_RUN_RESULTS rev_result

316: and p_effective_date between period.start_date and period.end_date
317: -- change 115.12
318: and NOT EXISTS
319: (SELECT 1
320: FROM PAY_RUN_RESULTS rev_result
321: WHERE rev_result.source_id = result.run_result_id
322: and rev_result.source_type in ('R', 'V'));
323: --
324: -- Retropay by Element Entry for unprocessed recurring entry

Line 661: -- from pay_run_results pr1

657: -- and ent.entry_type <> 'E'
658: -- )
659: -- )
660: -- and (not exists ( select 'x'
661: -- from pay_run_results pr1
662: -- , pay_assignment_actions asa2
663: -- where pr1.source_id = ent.element_entry_id
664: -- and pr1.source_type = 'E'
665: -- and pr1.status <> 'U'

Line 678: -- from pay_run_results pr1

674: -- )
675: -- )
676: -- )
677: -- or exists (select null
678: -- from pay_run_results pr1
679: -- where pr1.source_id = ent.element_entry_id
680: -- and pr1.source_type = 'E'
681: -- and pr1.status = 'U'
682: -- )