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 90: pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id,

86: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
87: c_start_person_id in per_all_people_f.person_id%type,
88: c_end_person_id in per_all_people_f.person_id%type) is
89: select distinct a.assignment_id,
90: pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id,
91: ppac.assignment_action_id
92: from per_assignments_f a,
93: per_people_f p,
94: pay_payroll_actions pa,

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

99: and p.person_id = a.person_id
100: and p.business_group_id = pa.business_group_id
101: and ppa.payroll_action_id = ppac.payroll_action_id
102: and a.assignment_id = ppac.assignment_id
103: and ppa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters)
104: And ppa.action_type = 'X'
105: and ppa.action_status = 'C'
106: and pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES' --3098353
107: and pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG', ppac.assignment_action_id)='NO' --3937976

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

114: from pay_assignment_actions ppac1,
115: pay_payroll_Actions ppaa
116: where ppaa.action_type ='X'
117: and ppaa.action_status ='C'
118: and pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppaa.legislative_parameters) =
119: pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pa.legislative_parameters) --2610141
120: and ppaa.report_type ='AU_PAYMENT_SUMMARY'
121: and ppaa.payroll_Action_id = ppac1.payroll_action_id
122: group by ppac1.assignment_id);

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

115: pay_payroll_Actions ppaa
116: where ppaa.action_type ='X'
117: and ppaa.action_status ='C'
118: and pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppaa.legislative_parameters) =
119: pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pa.legislative_parameters) --2610141
120: and ppaa.report_type ='AU_PAYMENT_SUMMARY'
121: and ppaa.payroll_Action_id = ppac1.payroll_action_id
122: group by ppac1.assignment_id);
123:

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

132:
133: CURSOR c_get_paysum_details
134: (c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
135: IS
136: SELECT to_number(pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppa.legislative_parameters)) registered_employer
137: ,pay_core_utils.get_parameter('ARCHIVE_ID', ppa.legislative_parameters) archive_id
138: ,NVL(pay_core_utils.get_parameter('PAY_SUM_TYPE', ppa.legislative_parameters),'O') payment_summary_type
139: ,pay_core_utils.get_parameter('FINANCIAL_YEAR', ppa.legislative_parameters) fin_year
140: FROM pay_payroll_actions ppa

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

133: CURSOR c_get_paysum_details
134: (c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
135: IS
136: SELECT to_number(pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppa.legislative_parameters)) registered_employer
137: ,pay_core_utils.get_parameter('ARCHIVE_ID', ppa.legislative_parameters) archive_id
138: ,NVL(pay_core_utils.get_parameter('PAY_SUM_TYPE', ppa.legislative_parameters),'O') payment_summary_type
139: ,pay_core_utils.get_parameter('FINANCIAL_YEAR', ppa.legislative_parameters) fin_year
140: FROM pay_payroll_actions ppa
141: WHERE ppa.payroll_action_id = c_payroll_action_id;

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

134: (c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
135: IS
136: SELECT to_number(pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppa.legislative_parameters)) registered_employer
137: ,pay_core_utils.get_parameter('ARCHIVE_ID', ppa.legislative_parameters) archive_id
138: ,NVL(pay_core_utils.get_parameter('PAY_SUM_TYPE', ppa.legislative_parameters),'O') payment_summary_type
139: ,pay_core_utils.get_parameter('FINANCIAL_YEAR', ppa.legislative_parameters) fin_year
140: FROM pay_payroll_actions ppa
141: WHERE ppa.payroll_action_id = c_payroll_action_id;
142:

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

135: IS
136: SELECT to_number(pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppa.legislative_parameters)) registered_employer
137: ,pay_core_utils.get_parameter('ARCHIVE_ID', ppa.legislative_parameters) archive_id
138: ,NVL(pay_core_utils.get_parameter('PAY_SUM_TYPE', ppa.legislative_parameters),'O') payment_summary_type
139: ,pay_core_utils.get_parameter('FINANCIAL_YEAR', ppa.legislative_parameters) fin_year
140: FROM pay_payroll_actions ppa
141: WHERE ppa.payroll_action_id = c_payroll_action_id;
142:
143:

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

149: ,c_reg_emp IN pay_assignment_actions.tax_unit_id%TYPE
150: ,c_financial_year VARCHAR2)
151: IS
152: SELECT DISTINCT a.assignment_id
153: ,pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id
154: ,ppac.assignment_action_id
155: ,pmaa.assignment_action_id datafile_action_id
156: FROM per_assignments_f a
157: ,per_people_f p

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

176: AND pmaa.payroll_action_id = pmpa.payroll_action_id
177: AND pmpa.report_type = 'AU_PS_DATA_FILE'
178: AND pmpa.action_type = 'X'
179: AND pmpa.action_status = 'C'
180: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pmpa.legislative_parameters) = c_reg_emp
181: AND pay_core_utils.get_parameter('FINANCIAL_YEAR', pmpa.legislative_parameters) = c_financial_year
182: AND NOT EXISTS
183: (SELECT locked_action_id
184: FROM pay_action_interlocks pail

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

177: AND pmpa.report_type = 'AU_PS_DATA_FILE'
178: AND pmpa.action_type = 'X'
179: AND pmpa.action_status = 'C'
180: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pmpa.legislative_parameters) = c_reg_emp
181: AND pay_core_utils.get_parameter('FINANCIAL_YEAR', pmpa.legislative_parameters) = c_financial_year
182: AND NOT EXISTS
183: (SELECT locked_action_id
184: FROM pay_action_interlocks pail
185: WHERE pail.locked_action_id=ppac.assignment_action_id)

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

188: FROM pay_assignment_actions ppac1,
189: pay_payroll_Actions ppaa
190: WHERE ppaa.action_type ='X'
191: AND ppaa.action_status ='C'
192: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppaa.legislative_parameters) =
193: pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pa.legislative_parameters) --2610141
194: AND ppaa.report_type ='AU_PAY_SUMM_AMEND'
195: AND ppaa.payroll_Action_id = ppac1.payroll_action_id
196: GROUP BY ppac1.assignment_id);

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

189: pay_payroll_Actions ppaa
190: WHERE ppaa.action_type ='X'
191: AND ppaa.action_status ='C'
192: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER', ppaa.legislative_parameters) =
193: pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pa.legislative_parameters) --2610141
194: AND ppaa.report_type ='AU_PAY_SUMM_AMEND'
195: AND ppaa.payroll_Action_id = ppac1.payroll_action_id
196: GROUP BY ppac1.assignment_id);
197:

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

350: from pay_au_eoy_values_v ppav,
351: pay_payroll_actions ppa,
352: pay_assignment_actions pac
353: where ppa.payroll_action_id= p_payroll_action_id
354: and ppav.payroll_action_id =pay_core_utils.get_parameter('ARCHIVE_ID',ppa.legislative_parameters)
355: and ppa.report_type='AU_PAYMENT_SUMMARY_REPORT'
356: and ppav.assignment_id=pac.assignment_id
357: and ppav.X_REPORTING_FLAG = 'YES'
358: and ppav.X_CURR_TERM_0_BAL_FLAG='NO'

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

356: and ppav.assignment_id=pac.assignment_id
357: and ppav.X_REPORTING_FLAG = 'YES'
358: and ppav.X_CURR_TERM_0_BAL_FLAG='NO'
359: and pac.payroll_action_id=p_payroll_action_id
360: and decode(pay_core_utils.get_parameter('SS_PREF',ppa.legislative_parameters),'N',ss_pref(pac.assignment_id),'N') ='N'
361: ;
362:
363:
364: rec_print_options csr_get_print_options%ROWTYPE;