DBA Data[Home] [Help]

APPS.PAY_AU_TERMINATIONS dependencies on PAY_RUN_RESULTS

Line 528: from pay_run_results

524: -- Define how to determine if the entry is processed
525: --
526: cursor nonrecurring_entries is
527: select 'Y'
528: from pay_run_results
529: where source_id = p_element_entry_id
530: and status <> 'U';
531: --
532: -- Bug 522510, recurring entries are considered as processed in the Date Earned period,

Line 539: from pay_run_results RESULT

535:
536: -- Bug No: 3603495 - Modified the following cursor - Performance Fix.
537: cursor recurring_entries is
538: select 'Y'
539: from pay_run_results RESULT
540: where result.source_id = l_source_id --Bug 3306112
541: and result.status <> 'U'
542: and exists ( select 1
543: from pay_assignment_actions ASGT_ACTION