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 pay_au_payment_summary_magtape as

1: package pay_au_payment_summary_magtape as
2: /* $Header: pyaupsm.pkh 120.6.12010000.2 2008/08/06 06:50:56 ubhat ship $*/
3:
4: level_cnt number;
5:

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

43: from pay_assignment_actions ppac,
44: pay_payroll_actions ppa
45: where ppa.payroll_action_id =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
46: and ppac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',ppa.legislative_parameters)
47: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'
48: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',ppac.assignment_action_id)='NO' /* Added for bug 5257622 */
49: and ppac.action_status = 'C'
50: and ppa.report_type = 'AU_PS_DATA_FILE_VAL'
51: and ppa.report_qualifier = 'AU'

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

44: pay_payroll_actions ppa
45: where ppa.payroll_action_id =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
46: and ppac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',ppa.legislative_parameters)
47: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'
48: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',ppac.assignment_action_id)='NO' /* Added for bug 5257622 */
49: and ppac.action_status = 'C'
50: and ppa.report_type = 'AU_PS_DATA_FILE_VAL'
51: and ppa.report_qualifier = 'AU'
52: and ppa.report_category = 'REPORT'

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

102: ff_user_entities fue
103: where ppa.payroll_action_id =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
104: and ppac.action_status='C'
105: and ppac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',ppa.legislative_parameters)
106: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'
107: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',ppac.assignment_action_id)='NO' /* Added for bug 5257622 */
108: and fue.user_Entity_id= ff.user_entity_id
109: and ff.context1= ppac.assignment_action_id
110: and ppa.report_type = 'AU_PS_DATA_FILE_VAL'

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

103: where ppa.payroll_action_id =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
104: and ppac.action_status='C'
105: and ppac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',ppa.legislative_parameters)
106: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'
107: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',ppac.assignment_action_id)='NO' /* Added for bug 5257622 */
108: and fue.user_Entity_id= ff.user_entity_id
109: and ff.context1= ppac.assignment_action_id
110: and ppa.report_type = 'AU_PS_DATA_FILE_VAL'
111: and ppa.report_qualifier = 'AU'

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

167: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
168: AND mpac.payroll_action_id = mpa.payroll_action_id /* Added for bug 6630375 */
169: AND mpac.assignment_id = ppac.assignment_id /* Added for bug 6630375 */
170: AND ppac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',mpa.legislative_parameters)
171: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'
172: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',ppac.assignment_action_id)='NO' /* Added for bug 5257622 */
173: and ppac.action_status = 'C'
174: and mpa.report_type = 'AU_PS_DATA_FILE_VAL'
175: and mpa.report_qualifier = 'AU'

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

168: AND mpac.payroll_action_id = mpa.payroll_action_id /* Added for bug 6630375 */
169: AND mpac.assignment_id = ppac.assignment_id /* Added for bug 6630375 */
170: AND ppac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',mpa.legislative_parameters)
171: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'
172: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',ppac.assignment_action_id)='NO' /* Added for bug 5257622 */
173: and ppac.action_status = 'C'
174: and mpa.report_type = 'AU_PS_DATA_FILE_VAL'
175: and mpa.report_qualifier = 'AU'
176: and mpa.report_category = 'REPORT'

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

250: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
251: AND mpac.payroll_action_id = mpa.payroll_action_id /* Added for bug 6630375 */
252: AND mpac.assignment_id = ppac.assignment_id /* Added for bug 6630375 */
253: AND ppac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',mpa.legislative_parameters)
254: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'
255: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',ppac.assignment_action_id)='NO' /* Added for bug 5257622 */
256: and pay_au_payment_summary.get_archive_value('X_SORT_EMPLOYEE_TYPE',ppac.assignment_action_id) = 'T'
257: and ppac.action_status = 'C'
258: and mpa.report_type = 'AU_PS_DATA_FILE_VAL'

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

251: AND mpac.payroll_action_id = mpa.payroll_action_id /* Added for bug 6630375 */
252: AND mpac.assignment_id = ppac.assignment_id /* Added for bug 6630375 */
253: AND ppac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',mpa.legislative_parameters)
254: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'
255: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',ppac.assignment_action_id)='NO' /* Added for bug 5257622 */
256: and pay_au_payment_summary.get_archive_value('X_SORT_EMPLOYEE_TYPE',ppac.assignment_action_id) = 'T'
257: and ppac.action_status = 'C'
258: and mpa.report_type = 'AU_PS_DATA_FILE_VAL'
259: and mpa.report_qualifier = 'AU'

Line 256: and pay_au_payment_summary.get_archive_value('X_SORT_EMPLOYEE_TYPE',ppac.assignment_action_id) = 'T'

252: AND mpac.assignment_id = ppac.assignment_id /* Added for bug 6630375 */
253: AND ppac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',mpa.legislative_parameters)
254: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'
255: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',ppac.assignment_action_id)='NO' /* Added for bug 5257622 */
256: and pay_au_payment_summary.get_archive_value('X_SORT_EMPLOYEE_TYPE',ppac.assignment_action_id) = 'T'
257: and ppac.action_status = 'C'
258: and mpa.report_type = 'AU_PS_DATA_FILE_VAL'
259: and mpa.report_qualifier = 'AU'
260: and mpa.report_category = 'REPORT'

Line 294: and pay_au_payment_summary.get_archive_value('X_SORT_EMPLOYEE_TYPE',apac.assignment_action_id) = 'T'

290: and ppac.assignment_action_id = mpai.locked_action_id
291: and ppai.locking_Action_id = ppac.assignment_action_id
292: and apac.assignment_action_id = ppai.locked_action_id
293: and apac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID',ppa.legislative_parameters)
294: and pay_au_payment_summary.get_archive_value('X_SORT_EMPLOYEE_TYPE',apac.assignment_action_id) = 'T'
295: and ppa.payroll_action_id = ppac.payroll_Action_id
296: and ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'
297: and apac.assignment_id = ppac.assignment_id
298: and ppac.assignment_id = mpac.assignment_id

Line 313: end pay_au_payment_summary_magtape;

309: )
310: group by apac.assignment_action_id;
311:
312:
313: end pay_au_payment_summary_magtape;