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.9.12020000.2 2013/02/04 05:47:10 skshin 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.9.12020000.2 2013/02/04 05:47:10 skshin 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 178: and pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES' --3098353

174: and a.assignment_id = ppac.assignment_id
175: and ppa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters)
176: And ppa.action_type = 'X'
177: and ppa.action_status = 'C'
178: and pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES' --3098353
179: and pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG', ppac.assignment_action_id)='NO' --3937976
180: and not exists
181: (select locked_action_id
182: FROM pay_action_interlocks pail

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

175: and ppa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters)
176: And ppa.action_type = 'X'
177: and ppa.action_status = 'C'
178: and pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES' --3098353
179: and pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG', ppac.assignment_action_id)='NO' --3937976
180: and not exists
181: (select locked_action_id
182: FROM pay_action_interlocks pail
183: WHERE pail.locked_action_id=ppac.assignment_action_id)

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

232: AND ppa.report_qualifier = 'AU'
233: AND ppa.report_category = 'REPORT'
234: AND ppa.action_type = 'X'
235: AND ppa.action_status = 'C'
236: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'
237: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG', ppac.assignment_action_id)='NO'
238: AND NOT EXISTS
239: (SELECT locked_action_id
240: FROM pay_action_interlocks pail

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

233: AND ppa.report_category = 'REPORT'
234: AND ppa.action_type = 'X'
235: AND ppa.action_status = 'C'
236: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'
237: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG', ppac.assignment_action_id)='NO'
238: AND NOT EXISTS
239: (SELECT locked_action_id
240: FROM pay_action_interlocks pail
241: WHERE pail.locked_action_id = ppac.assignment_action_id)

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

303: AND a.assignment_id = ppac.assignment_id
304: AND ppa.payroll_action_id = c_archive_id
305: AND ppa.action_type = 'X'
306: AND ppa.action_status = 'C'
307: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'
308: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG', ppac.assignment_action_id)='NO'
309: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', ppac.assignment_action_id)='A' /* Indicates something has changed */
310: AND pmaa.assignment_id = ppac.assignment_id
311: AND pmaa.payroll_action_id = pmpa.payroll_action_id

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

304: AND ppa.payroll_action_id = c_archive_id
305: AND ppa.action_type = 'X'
306: AND ppa.action_status = 'C'
307: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'
308: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG', ppac.assignment_action_id)='NO'
309: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', ppac.assignment_action_id)='A' /* Indicates something has changed */
310: AND pmaa.assignment_id = ppac.assignment_id
311: AND pmaa.payroll_action_id = pmpa.payroll_action_id
312: AND pmpa.report_type = 'AU_PS_DATA_FILE'

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

305: AND ppa.action_type = 'X'
306: AND ppa.action_status = 'C'
307: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'
308: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG', ppac.assignment_action_id)='NO'
309: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', ppac.assignment_action_id)='A' /* Indicates something has changed */
310: AND pmaa.assignment_id = ppac.assignment_id
311: AND pmaa.payroll_action_id = pmpa.payroll_action_id
312: AND pmpa.report_type = 'AU_PS_DATA_FILE'
313: AND pmpa.action_type = 'X'

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

365: AND a.assignment_id = ppac.assignment_id
366: AND ppa.payroll_action_id = c_archive_id
367: AND ppa.action_type = 'X'
368: AND ppa.action_status = 'C'
369: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'
370: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG', ppac.assignment_action_id)='NO'
371: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', ppac.assignment_action_id)='A'
372: AND pmaa.assignment_id = ppac.assignment_id
373: AND pmaa.payroll_action_id = pmpa.payroll_action_id

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

366: AND ppa.payroll_action_id = c_archive_id
367: AND ppa.action_type = 'X'
368: AND ppa.action_status = 'C'
369: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'
370: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG', ppac.assignment_action_id)='NO'
371: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', ppac.assignment_action_id)='A'
372: AND pmaa.assignment_id = ppac.assignment_id
373: AND pmaa.payroll_action_id = pmpa.payroll_action_id
374: AND pmpa.report_type = 'AU_PS_DATA_FILE'

Line 371: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', ppac.assignment_action_id)='A'

367: AND ppa.action_type = 'X'
368: AND ppa.action_status = 'C'
369: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'
370: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG', ppac.assignment_action_id)='NO'
371: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', ppac.assignment_action_id)='A'
372: AND pmaa.assignment_id = ppac.assignment_id
373: AND pmaa.payroll_action_id = pmpa.payroll_action_id
374: AND pmpa.report_type = 'AU_PS_DATA_FILE'
375: AND pmpa.action_type = 'X'

Line 898: END pay_au_payment_summary_report;

894:
895: return l_online_opt;
896: end;
897:
898: END pay_au_payment_summary_report;