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_CORE_UTILS

Line 54: SELECT pay_core_utils.get_parameter('IS_TESTING',ppa.legislative_parameters),

50:
51:
52: CURSOR get_parameters
53: IS
54: SELECT pay_core_utils.get_parameter('IS_TESTING',ppa.legislative_parameters),
55: pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',ppa.legislative_parameters),
56: pay_core_utils.get_parameter('PAYMENT_SUMMARY_TYPE',ppa.legislative_parameters) /* bug 6630375 */
57: FROM pay_payroll_actions ppa
58: WHERE ppa.payroll_Action_id = p_payroll_action_id;

Line 55: pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',ppa.legislative_parameters),

51:
52: CURSOR get_parameters
53: IS
54: SELECT pay_core_utils.get_parameter('IS_TESTING',ppa.legislative_parameters),
55: pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',ppa.legislative_parameters),
56: pay_core_utils.get_parameter('PAYMENT_SUMMARY_TYPE',ppa.legislative_parameters) /* bug 6630375 */
57: FROM pay_payroll_actions ppa
58: WHERE ppa.payroll_Action_id = p_payroll_action_id;
59:

Line 56: pay_core_utils.get_parameter('PAYMENT_SUMMARY_TYPE',ppa.legislative_parameters) /* bug 6630375 */

52: CURSOR get_parameters
53: IS
54: SELECT pay_core_utils.get_parameter('IS_TESTING',ppa.legislative_parameters),
55: pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',ppa.legislative_parameters),
56: pay_core_utils.get_parameter('PAYMENT_SUMMARY_TYPE',ppa.legislative_parameters) /* bug 6630375 */
57: FROM pay_payroll_actions ppa
58: WHERE ppa.payroll_Action_id = p_payroll_action_id;
59:
60:

Line 113: AND apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID',ppa.legislative_parameters)

109: AND apac.assignment_action_id = ppai.locked_action_id
110: AND ppac.assignment_action_id = ppai.locking_action_id
111: and apa.action_status = 'C'
112: AND ppa.action_status = 'C'
113: AND apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID',ppa.legislative_parameters)
114: AND a.assignment_id = apac.assignment_id
115: AND a.assignment_id = ppac.assignment_id
116: AND apa.report_type ='AU_PAYMENT_SUMMARY'
117: AND ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'

Line 118: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=

114: AND a.assignment_id = apac.assignment_id
115: AND a.assignment_id = ppac.assignment_id
116: AND apa.report_type ='AU_PAYMENT_SUMMARY'
117: AND ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'
118: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=
119: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
120: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
121: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
122: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=

Line 119: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)

115: AND a.assignment_id = ppac.assignment_id
116: AND apa.report_type ='AU_PAYMENT_SUMMARY'
117: AND ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'
118: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=
119: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
120: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
121: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
122: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
123: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)

Line 120: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=

116: AND apa.report_type ='AU_PAYMENT_SUMMARY'
117: AND ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'
118: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=
119: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
120: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
121: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
122: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
123: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
124: AND NOT EXISTS /* 5471093 */

Line 121: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)

117: AND ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'
118: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=
119: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
120: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
121: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
122: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
123: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
124: AND NOT EXISTS /* 5471093 */
125: (SELECT /*+ ORDERED */ locked_action_id

Line 122: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=

118: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=
119: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
120: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
121: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
122: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
123: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
124: AND NOT EXISTS /* 5471093 */
125: (SELECT /*+ ORDERED */ locked_action_id
126: FROM pay_action_interlocks pail,

Line 123: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)

119: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
120: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
121: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
122: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
123: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
124: AND NOT EXISTS /* 5471093 */
125: (SELECT /*+ ORDERED */ locked_action_id
126: FROM pay_action_interlocks pail,
127: pay_assignment_actions paa1,

Line 190: AND apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID',ppa.legislative_parameters)

186: AND apac.assignment_action_id = ppai.locked_action_id
187: AND ppac.assignment_action_id = ppai.locking_action_id
188: and apa.action_status = 'C'
189: AND ppa.action_status = 'C'
190: AND apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID',ppa.legislative_parameters)
191: AND a.assignment_id = apac.assignment_id
192: AND a.assignment_id = ppac.assignment_id
193: AND apa.report_type ='AU_PAY_SUMM_AMEND'
194: AND ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'

Line 195: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=

191: AND a.assignment_id = apac.assignment_id
192: AND a.assignment_id = ppac.assignment_id
193: AND apa.report_type ='AU_PAY_SUMM_AMEND'
194: AND ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'
195: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=
196: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
197: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
198: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
199: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=

Line 196: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)

192: AND a.assignment_id = ppac.assignment_id
193: AND apa.report_type ='AU_PAY_SUMM_AMEND'
194: AND ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'
195: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=
196: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
197: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
198: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
199: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
200: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)

Line 197: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=

193: AND apa.report_type ='AU_PAY_SUMM_AMEND'
194: AND ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'
195: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=
196: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
197: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
198: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
199: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
200: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
201: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', apac.assignment_action_id)='A'

Line 198: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)

194: AND ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'
195: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=
196: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
197: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
198: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
199: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
200: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
201: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', apac.assignment_action_id)='A'
202: AND NOT EXISTS /* 5471093 */

Line 199: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=

195: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=
196: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
197: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
198: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
199: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
200: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
201: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', apac.assignment_action_id)='A'
202: AND NOT EXISTS /* 5471093 */
203: (SELECT /*+ ORDERED */ locked_action_id

Line 200: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)

196: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
197: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
198: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
199: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
200: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
201: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', apac.assignment_action_id)='A'
202: AND NOT EXISTS /* 5471093 */
203: (SELECT /*+ ORDERED */ locked_action_id
204: FROM pay_action_interlocks pail,