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_PAYMENT_SUMMARY_REPORT dependencies on PAY_AU_PAYMENT_SUMMARY

Line 1: package body pay_au_payment_summary_report as

1: package body pay_au_payment_summary_report as
2: /* $Header: pyaupsrp.pkb 120.4.12010000.3 2008/08/06 06:53:21 ubhat ship $*/
3: /*
4: *** ------------------------------------------------------------------------+
5: *** Program: pay_au_payment_summary_report (Package Body)

Line 5: *** Program: pay_au_payment_summary_report (Package Body)

1: package body pay_au_payment_summary_report as
2: /* $Header: pyaupsrp.pkb 120.4.12010000.3 2008/08/06 06:53:21 ubhat ship $*/
3: /*
4: *** ------------------------------------------------------------------------+
5: *** Program: pay_au_payment_summary_report (Package Body)
6: ***
7: *** Change History
8: ***
9: *** Date Changed By Version Description of Change

Line 106: and pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES' --3098353

102: and a.assignment_id = ppac.assignment_id
103: and ppa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters)
104: And ppa.action_type = 'X'
105: and ppa.action_status = 'C'
106: and pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES' --3098353
107: and pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG', ppac.assignment_action_id)='NO' --3937976
108: and not exists
109: (select locked_action_id
110: FROM pay_action_interlocks pail

Line 107: and pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG', ppac.assignment_action_id)='NO' --3937976

103: and ppa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters)
104: And ppa.action_type = 'X'
105: and ppa.action_status = 'C'
106: and pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES' --3098353
107: and pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG', ppac.assignment_action_id)='NO' --3937976
108: and not exists
109: (select locked_action_id
110: FROM pay_action_interlocks pail
111: WHERE pail.locked_action_id=ppac.assignment_action_id)

Line 172: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'

168: AND a.assignment_id = ppac.assignment_id
169: AND ppa.payroll_action_id = c_archive_id
170: AND ppa.action_type = 'X'
171: AND ppa.action_status = 'C'
172: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'
173: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG', ppac.assignment_action_id)='NO'
174: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', ppac.assignment_action_id)='A' /* Indicates something has changed */
175: AND pmaa.assignment_id = ppac.assignment_id
176: AND pmaa.payroll_action_id = pmpa.payroll_action_id

Line 173: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG', ppac.assignment_action_id)='NO'

169: AND ppa.payroll_action_id = c_archive_id
170: AND ppa.action_type = 'X'
171: AND ppa.action_status = 'C'
172: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'
173: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG', ppac.assignment_action_id)='NO'
174: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', ppac.assignment_action_id)='A' /* Indicates something has changed */
175: AND pmaa.assignment_id = ppac.assignment_id
176: AND pmaa.payroll_action_id = pmpa.payroll_action_id
177: AND pmpa.report_type = 'AU_PS_DATA_FILE'

Line 174: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', ppac.assignment_action_id)='A' /* Indicates something has changed */

170: AND ppa.action_type = 'X'
171: AND ppa.action_status = 'C'
172: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'
173: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG', ppac.assignment_action_id)='NO'
174: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', ppac.assignment_action_id)='A' /* Indicates something has changed */
175: AND pmaa.assignment_id = ppac.assignment_id
176: AND pmaa.payroll_action_id = pmpa.payroll_action_id
177: AND pmpa.report_type = 'AU_PS_DATA_FILE'
178: AND pmpa.action_type = 'X'

Line 641: END pay_au_payment_summary_report;

637:
638: return l_online_opt;
639: end;
640:
641: END pay_au_payment_summary_report;