eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_TERMINATIONS dependencies on PAY_RUN_RESULTS

Line 612: from pay_run_results

608: -- Define how to determine if the entry is processed
609: --
610: cursor nonrecurring_entries is
611: select 'Y'
612: from pay_run_results
613: where source_id = p_element_entry_id
614: and status <> 'U';
615: --
616: -- Bug 522510, recurring entries are considered as processed in the Date Earned period,

Line 623: from pay_run_results RESULT

619:
620: -- Bug No: 3603495 - Modified the following cursor - Performance Fix.
621: cursor recurring_entries is
622: select 'Y'
623: from pay_run_results RESULT
624: where result.source_id = l_source_id --Bug 3306112
625: and result.status <> 'U'
626: and exists ( select 1
627: from pay_assignment_actions ASGT_ACTION

Line 2223: and not exists ( select 1 from pay_run_results prr

2219: and p_date_earned between pee.effective_start_date and pee.effective_end_date
2220: and p_date_earned between peev.effective_start_date and peev.effective_end_date
2221: and p_date_earned between pet.effective_start_date and pet.effective_end_date
2222: and p_date_earned between piv.effective_start_date and piv.effective_end_date
2223: and not exists ( select 1 from pay_run_results prr
2224: where prr.element_entry_id = pee.element_entry_id
2225: and prr.element_type_id = pet.element_type_id
2226: and prr.element_type_id = pee.element_type_id
2227: and prr.assignment_action_id <> p_assignment_action_id)