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_CORE_UTILS

Line 162: pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id,

158: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
159: c_start_person_id in per_all_people_f.person_id%type,
160: c_end_person_id in per_all_people_f.person_id%type) is
161: select distinct a.assignment_id,
162: pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id,
163: ppac.assignment_action_id
164: from per_assignments_f a,
165: per_people_f p,
166: pay_payroll_actions pa,

Line 175: and ppa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters)

171: and p.person_id = a.person_id
172: and p.business_group_id = pa.business_group_id
173: and ppa.payroll_action_id = ppac.payroll_action_id
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

Line 190: and pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppaa.legislative_parameters) =

186: from pay_assignment_actions ppac1,
187: pay_payroll_Actions ppaa
188: where ppaa.action_type ='X'
189: and ppaa.action_status ='C'
190: and pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppaa.legislative_parameters) =
191: pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pa.legislative_parameters) --2610141
192: and ppaa.report_type ='AU_PAYMENT_SUMMARY'
193: and ppaa.payroll_Action_id = ppac1.payroll_action_id
194: group by ppac1.assignment_id);

Line 191: pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pa.legislative_parameters) --2610141

187: pay_payroll_Actions ppaa
188: where ppaa.action_type ='X'
189: and ppaa.action_status ='C'
190: and pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppaa.legislative_parameters) =
191: pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pa.legislative_parameters) --2610141
192: and ppaa.report_type ='AU_PAYMENT_SUMMARY'
193: and ppaa.payroll_Action_id = ppac1.payroll_action_id
194: group by ppac1.assignment_id);
195:

Line 214: pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id,

210: c_chunk in NUMBER)
211: IS
212: SELECT /*+ ORDERED */
213: DISTINCT a.assignment_id,
214: pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id,
215: ppac.assignment_action_id
216: FROM pay_payroll_actions pa,
217: pay_population_ranges ppr,
218: pay_payroll_actions ppa,

Line 230: AND ppa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters)

226: AND p.person_id = a.person_id
227: AND p.business_group_id = pa.business_group_id
228: AND ppa.payroll_action_id = ppac.payroll_action_id
229: AND a.assignment_id = ppac.assignment_id
230: AND ppa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters)
231: AND ppa.report_type = 'AU_PAYMENT_SUMMARY'
232: AND ppa.report_qualifier = 'AU'
233: AND ppa.report_category = 'REPORT'
234: AND ppa.action_type = 'X'

Line 248: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppaa.legislative_parameters) =

244: FROM pay_assignment_actions ppac1,
245: pay_payroll_Actions ppaa
246: where ppaa.action_type ='X'
247: AND ppaa.action_status ='C'
248: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppaa.legislative_parameters) =
249: pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pa.legislative_parameters)
250: AND ppaa.report_type = 'AU_PAYMENT_SUMMARY'
251: AND ppaa.report_qualifier = 'AU'
252: AND ppaa.report_category = 'REPORT'

Line 249: pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pa.legislative_parameters)

245: pay_payroll_Actions ppaa
246: where ppaa.action_type ='X'
247: AND ppaa.action_status ='C'
248: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppaa.legislative_parameters) =
249: pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pa.legislative_parameters)
250: AND ppaa.report_type = 'AU_PAYMENT_SUMMARY'
251: AND ppaa.report_qualifier = 'AU'
252: AND ppaa.report_category = 'REPORT'
253: AND ppac1.assignment_id = ppac.assignment_id

Line 271: SELECT to_number(pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppa.legislative_parameters)) registered_employer

267:
268: CURSOR c_get_paysum_details
269: (c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
270: IS
271: SELECT to_number(pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppa.legislative_parameters)) registered_employer
272: ,pay_core_utils.get_parameter('ARCHIVE_ID', ppa.legislative_parameters) archive_id
273: ,NVL(pay_core_utils.get_parameter('PAY_SUM_TYPE', ppa.legislative_parameters),'O') payment_summary_type
274: ,pay_core_utils.get_parameter('FINANCIAL_YEAR', ppa.legislative_parameters) fin_year
275: FROM pay_payroll_actions ppa

Line 272: ,pay_core_utils.get_parameter('ARCHIVE_ID', ppa.legislative_parameters) archive_id

268: CURSOR c_get_paysum_details
269: (c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
270: IS
271: SELECT to_number(pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppa.legislative_parameters)) registered_employer
272: ,pay_core_utils.get_parameter('ARCHIVE_ID', ppa.legislative_parameters) archive_id
273: ,NVL(pay_core_utils.get_parameter('PAY_SUM_TYPE', ppa.legislative_parameters),'O') payment_summary_type
274: ,pay_core_utils.get_parameter('FINANCIAL_YEAR', ppa.legislative_parameters) fin_year
275: FROM pay_payroll_actions ppa
276: WHERE ppa.payroll_action_id = c_payroll_action_id;

Line 273: ,NVL(pay_core_utils.get_parameter('PAY_SUM_TYPE', ppa.legislative_parameters),'O') payment_summary_type

269: (c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
270: IS
271: SELECT to_number(pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppa.legislative_parameters)) registered_employer
272: ,pay_core_utils.get_parameter('ARCHIVE_ID', ppa.legislative_parameters) archive_id
273: ,NVL(pay_core_utils.get_parameter('PAY_SUM_TYPE', ppa.legislative_parameters),'O') payment_summary_type
274: ,pay_core_utils.get_parameter('FINANCIAL_YEAR', ppa.legislative_parameters) fin_year
275: FROM pay_payroll_actions ppa
276: WHERE ppa.payroll_action_id = c_payroll_action_id;
277:

Line 274: ,pay_core_utils.get_parameter('FINANCIAL_YEAR', ppa.legislative_parameters) fin_year

270: IS
271: SELECT to_number(pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppa.legislative_parameters)) registered_employer
272: ,pay_core_utils.get_parameter('ARCHIVE_ID', ppa.legislative_parameters) archive_id
273: ,NVL(pay_core_utils.get_parameter('PAY_SUM_TYPE', ppa.legislative_parameters),'O') payment_summary_type
274: ,pay_core_utils.get_parameter('FINANCIAL_YEAR', ppa.legislative_parameters) fin_year
275: FROM pay_payroll_actions ppa
276: WHERE ppa.payroll_action_id = c_payroll_action_id;
277:
278:

Line 288: ,pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id

284: ,c_reg_emp IN pay_assignment_actions.tax_unit_id%TYPE
285: ,c_financial_year VARCHAR2)
286: IS
287: SELECT DISTINCT a.assignment_id
288: ,pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id
289: ,ppac.assignment_action_id
290: ,pmaa.assignment_action_id datafile_action_id
291: FROM per_assignments_f a
292: ,per_people_f p

Line 315: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pmpa.legislative_parameters) = c_reg_emp

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'
314: AND pmpa.action_status = 'C'
315: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pmpa.legislative_parameters) = c_reg_emp
316: AND pay_core_utils.get_parameter('FINANCIAL_YEAR', pmpa.legislative_parameters) = c_financial_year
317: AND NOT EXISTS
318: (SELECT locked_action_id
319: FROM pay_action_interlocks pail

Line 316: AND pay_core_utils.get_parameter('FINANCIAL_YEAR', pmpa.legislative_parameters) = c_financial_year

312: AND pmpa.report_type = 'AU_PS_DATA_FILE'
313: AND pmpa.action_type = 'X'
314: AND pmpa.action_status = 'C'
315: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pmpa.legislative_parameters) = c_reg_emp
316: AND pay_core_utils.get_parameter('FINANCIAL_YEAR', pmpa.legislative_parameters) = c_financial_year
317: AND NOT EXISTS
318: (SELECT locked_action_id
319: FROM pay_action_interlocks pail
320: WHERE pail.locked_action_id=ppac.assignment_action_id)

Line 331: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppaa.legislative_parameters) =

327: FROM pay_assignment_actions ppac1,
328: pay_payroll_Actions ppaa
329: WHERE ppaa.action_type ='X'
330: AND ppaa.action_status ='C'
331: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppaa.legislative_parameters) =
332: pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pa.legislative_parameters) --2610141
333: AND ppaa.report_type ='AU_PAY_SUMM_AMEND'
334: AND ppaa.payroll_Action_id = ppac1.payroll_action_id
335: GROUP BY ppac1.assignment_id);

Line 332: pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pa.legislative_parameters) --2610141

328: pay_payroll_Actions ppaa
329: WHERE ppaa.action_type ='X'
330: AND ppaa.action_status ='C'
331: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppaa.legislative_parameters) =
332: pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pa.legislative_parameters) --2610141
333: AND ppaa.report_type ='AU_PAY_SUMM_AMEND'
334: AND ppaa.payroll_Action_id = ppac1.payroll_action_id
335: GROUP BY ppac1.assignment_id);
336:

Line 347: ,pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id

343: ,c_reg_emp IN pay_assignment_actions.tax_unit_id%TYPE
344: ,c_financial_year VARCHAR2)
345: IS
346: SELECT DISTINCT a.assignment_id
347: ,pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id
348: ,ppac.assignment_action_id
349: ,pmaa.assignment_action_id datafile_action_id
350: FROM per_assignments_f a
351: ,per_people_f p

Line 377: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pmpa.legislative_parameters) = c_reg_emp

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'
376: AND pmpa.action_status = 'C'
377: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pmpa.legislative_parameters) = c_reg_emp
378: AND pay_core_utils.get_parameter('FINANCIAL_YEAR', pmpa.legislative_parameters) = c_financial_year
379: AND NOT EXISTS
380: (SELECT locked_action_id
381: FROM pay_action_interlocks pail

Line 378: AND pay_core_utils.get_parameter('FINANCIAL_YEAR', pmpa.legislative_parameters) = c_financial_year

374: AND pmpa.report_type = 'AU_PS_DATA_FILE'
375: AND pmpa.action_type = 'X'
376: AND pmpa.action_status = 'C'
377: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pmpa.legislative_parameters) = c_reg_emp
378: AND pay_core_utils.get_parameter('FINANCIAL_YEAR', pmpa.legislative_parameters) = c_financial_year
379: AND NOT EXISTS
380: (SELECT locked_action_id
381: FROM pay_action_interlocks pail
382: WHERE pail.locked_action_id=ppac.assignment_action_id)

Line 393: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppaa.legislative_parameters) =

389: FROM pay_assignment_actions ppac1,
390: pay_payroll_Actions ppaa
391: WHERE ppaa.action_type ='X'
392: AND ppaa.action_status ='C'
393: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppaa.legislative_parameters) =
394: pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pa.legislative_parameters)
395: AND ppaa.report_type ='AU_PAY_SUMM_AMEND'
396: AND ppaa.payroll_Action_id = ppac1.payroll_action_id
397: GROUP BY ppac1.assignment_id);

Line 394: pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pa.legislative_parameters)

390: pay_payroll_Actions ppaa
391: WHERE ppaa.action_type ='X'
392: AND ppaa.action_status ='C'
393: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppaa.legislative_parameters) =
394: pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pa.legislative_parameters)
395: AND ppaa.report_type ='AU_PAY_SUMM_AMEND'
396: AND ppaa.payroll_Action_id = ppac1.payroll_action_id
397: GROUP BY ppac1.assignment_id);
398:

Line 611: and ppav.payroll_action_id =pay_core_utils.get_parameter('ARCHIVE_ID',ppa.legislative_parameters)

607: from pay_au_eoy_values_v ppav,
608: pay_payroll_actions ppa,
609: pay_assignment_actions pac
610: where ppa.payroll_action_id= p_payroll_action_id
611: and ppav.payroll_action_id =pay_core_utils.get_parameter('ARCHIVE_ID',ppa.legislative_parameters)
612: and ppa.report_type='AU_PAYMENT_SUMMARY_REPORT'
613: and ppav.assignment_id=pac.assignment_id
614: and ppav.X_REPORTING_FLAG = 'YES'
615: and ppav.X_CURR_TERM_0_BAL_FLAG='NO'

Line 617: and decode(pay_core_utils.get_parameter('SS_PREF',ppa.legislative_parameters),'N',ss_pref(pac.assignment_id),'N') ='N'

613: and ppav.assignment_id=pac.assignment_id
614: and ppav.X_REPORTING_FLAG = 'YES'
615: and ppav.X_CURR_TERM_0_BAL_FLAG='NO'
616: and pac.payroll_action_id=p_payroll_action_id
617: and decode(pay_core_utils.get_parameter('SS_PREF',ppa.legislative_parameters),'N',ss_pref(pac.assignment_id),'N') ='N'
618: ;
619:
620:
621: rec_print_options csr_get_print_options%ROWTYPE;