APPS.PAY_PAYWSMEE_PKG dependencies on PAY_RUN_RESULTS

Line 277: from pay_run_results prr,

273: -- Define how to determine if the entry is processed
274: --
275: cursor nonrecurring_entries (adjust_ee_source in varchar2) is
276: select 'Y'
277: from pay_run_results prr,
278: pay_element_entries_f pee
279: where pee.element_entry_id = p_element_entry_id
280: and p_effective_date between pee.effective_start_date
281: and pee.effective_end_date

Line 296: FROM PAY_RUN_RESULTS sub_rr

292: and prr.status <> 'U'
293: -- change 115.9
294: and NOT EXISTS
295: (SELECT 1
296: FROM PAY_RUN_RESULTS sub_rr
297: WHERE sub_rr.source_id = prr.run_result_id
298: and sub_rr.source_type in ('R', 'V'))
299: ;
300: --

Line 322: from pay_run_results RESULT,

318:
319: cursor recurring_entries is
320: --
321: select 'Y'
322: from pay_run_results RESULT,
323: pay_assignment_actions ASGT_ACTION,
324: pay_payroll_actions PAY_ACTION,
325: per_time_periods PERIOD
326: where result.source_id = nvl (p_original_entry_id, p_element_entry_id)

Line 337: FROM PAY_RUN_RESULTS rev_result

333: and p_effective_date between period.start_date and period.end_date
334: -- change 115.12
335: and NOT EXISTS
336: (SELECT 1
337: FROM PAY_RUN_RESULTS rev_result
338: WHERE rev_result.source_id = result.run_result_id
339: and rev_result.source_type in ('R', 'V'));
340: --
341: -- Retropay by Element Entry for unprocessed recurring entry

Line 685: -- from pay_run_results pr1

681: -- and ent.entry_type <> 'E'
682: -- )
683: -- )
684: -- and (not exists ( select 'x'
685: -- from pay_run_results pr1
686: -- , pay_assignment_actions asa2
687: -- where pr1.source_id = ent.element_entry_id
688: -- and pr1.source_type = 'E'
689: -- and pr1.status <> 'U'

Line 702: -- from pay_run_results pr1

698: -- )
699: -- )
700: -- )
701: -- or exists (select null
702: -- from pay_run_results pr1
703: -- where pr1.source_id = ent.element_entry_id
704: -- and pr1.source_type = 'E'
705: -- and pr1.status = 'U'
706: -- )