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

Line 1: package body pay_au_payment_summary_magtape as

1: package body pay_au_payment_summary_magtape as
2: /* $Header: pyaupsm.pkb 120.4.12010000.4 2009/12/16 14:17:37 dduvvuri ship $*/
3: -------------------------------------------------------------------------+
4:
5: -- g_debug boolean := hr_utility.debug_enabled; --Bug3132178

Line 140: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG',paa.assignment_action_id)='YES'

136: per_assignments_f a
137: WHERE paa.payroll_action_id = c_payroll_action_id
138: AND paa.action_status = 'C'
139: AND a.assignment_id = paa.assignment_id
140: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG',paa.assignment_action_id)='YES'
141: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',paa.assignment_action_id)='NO' /* Added for bug 5257622 */
142: AND a.person_id BETWEEN c_start_person_id AND c_end_person_id ;
143:
144: /* 9113084 - Added range cursor for above cursor process_assignments_val */

Line 141: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',paa.assignment_action_id)='NO' /* Added for bug 5257622 */

137: WHERE paa.payroll_action_id = c_payroll_action_id
138: AND paa.action_status = 'C'
139: AND a.assignment_id = paa.assignment_id
140: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG',paa.assignment_action_id)='YES'
141: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',paa.assignment_action_id)='NO' /* Added for bug 5257622 */
142: AND a.person_id BETWEEN c_start_person_id AND c_end_person_id ;
143:
144: /* 9113084 - Added range cursor for above cursor process_assignments_val */
145: /* 9113084 - Cursor to fetch assignments for Data File Validation when RANGE_PERSON_ID is enabled */

Line 161: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG',paa.assignment_action_id)='YES'

157: AND ppr.payroll_action_id = p_payroll_action_id
158: AND ppr.chunk_number = c_chunk
159: AND paa.action_status = 'C'
160: AND a.assignment_id = paa.assignment_id
161: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG',paa.assignment_action_id)='YES'
162: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',paa.assignment_action_id)='NO'
163: AND a.person_id = ppr.person_id ;
164:
165: --------End of Bug3132178--------------------------------------------------

Line 162: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',paa.assignment_action_id)='NO'

158: AND ppr.chunk_number = c_chunk
159: AND paa.action_status = 'C'
160: AND a.assignment_id = paa.assignment_id
161: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG',paa.assignment_action_id)='YES'
162: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',paa.assignment_action_id)='NO'
163: AND a.person_id = ppr.person_id ;
164:
165: --------End of Bug3132178--------------------------------------------------
166:

Line 314: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG',paa.assignment_action_id)='YES'

310: WHERE ppa.payroll_action_id = c_payroll_action_id
311: AND ppa.payroll_action_id = paa.payroll_action_id
312: AND ppa.action_status = 'C'
313: AND a.assignment_id = paa.assignment_id
314: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG',paa.assignment_action_id)='YES'
315: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',paa.assignment_action_id)='NO'
316: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE',paa.assignment_action_id)='A'
317: AND ppa.report_type = 'AU_PAY_SUMM_AMEND'
318: AND a.person_id BETWEEN c_start_person_id AND c_end_person_id ;

Line 315: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',paa.assignment_action_id)='NO'

311: AND ppa.payroll_action_id = paa.payroll_action_id
312: AND ppa.action_status = 'C'
313: AND a.assignment_id = paa.assignment_id
314: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG',paa.assignment_action_id)='YES'
315: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',paa.assignment_action_id)='NO'
316: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE',paa.assignment_action_id)='A'
317: AND ppa.report_type = 'AU_PAY_SUMM_AMEND'
318: AND a.person_id BETWEEN c_start_person_id AND c_end_person_id ;
319:

Line 316: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE',paa.assignment_action_id)='A'

312: AND ppa.action_status = 'C'
313: AND a.assignment_id = paa.assignment_id
314: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG',paa.assignment_action_id)='YES'
315: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',paa.assignment_action_id)='NO'
316: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE',paa.assignment_action_id)='A'
317: AND ppa.report_type = 'AU_PAY_SUMM_AMEND'
318: AND a.person_id BETWEEN c_start_person_id AND c_end_person_id ;
319:
320: /* 9113084 - Added below range cursor for above cursor process_assignments_val_amend */

Line 337: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG',paa.assignment_action_id)='YES'

333: AND ppr.payroll_action_id = p_payroll_action_id
334: AND ppr.chunk_number = c_chunk
335: AND paa.action_status = 'C'
336: AND a.assignment_id = paa.assignment_id
337: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG',paa.assignment_action_id)='YES'
338: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',paa.assignment_action_id)='NO'
339: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE',paa.assignment_action_id)='A'
340: AND a.person_id = ppr.person_id ;
341:

Line 338: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',paa.assignment_action_id)='NO'

334: AND ppr.chunk_number = c_chunk
335: AND paa.action_status = 'C'
336: AND a.assignment_id = paa.assignment_id
337: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG',paa.assignment_action_id)='YES'
338: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',paa.assignment_action_id)='NO'
339: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE',paa.assignment_action_id)='A'
340: AND a.person_id = ppr.person_id ;
341:
342:

Line 339: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE',paa.assignment_action_id)='A'

335: AND paa.action_status = 'C'
336: AND a.assignment_id = paa.assignment_id
337: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG',paa.assignment_action_id)='YES'
338: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',paa.assignment_action_id)='NO'
339: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE',paa.assignment_action_id)='A'
340: AND a.person_id = ppr.person_id ;
341:
342:
343: CURSOR process_assignments_amend /* bug 6630375 */

Line 385: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', apac.assignment_action_id)='A'

381: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
382: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
383: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
384: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
385: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', apac.assignment_action_id)='A'
386: AND NOT EXISTS /* 5471093 */
387: (SELECT /*+ ORDERED */ locked_action_id
388: FROM pay_action_interlocks pail,
389: pay_assignment_actions paa1,

Line 445: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', apac.assignment_action_id)='A'

441: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
442: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
443: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
444: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
445: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', apac.assignment_action_id)='A'
446: AND NOT EXISTS
447: (SELECT /*+ ORDERED */ locked_action_id
448: FROM pay_action_interlocks pail,
449: pay_assignment_actions paa1,

Line 728: End pay_au_payment_summary_magtape;

724: END IF;
725: end archive_code;
726: ---------------------------------------------------------------------------+
727:
728: End pay_au_payment_summary_magtape;