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_ASSIGNMENT_ACTIONS

Line 152: v_next_action_id pay_assignment_actions.assignment_action_id%type;

148: p_start_person_id in per_all_people_f.person_id%type,
149: p_end_person_id in per_all_people_f.person_id%type,
150: p_chunk in number) is
151:
152: v_next_action_id pay_assignment_actions.assignment_action_id%type;
153:
154: /*Bug2920725 Corrected base tables to support security model*/
155:
156:

Line 168: pay_assignment_actions ppac

164: from per_assignments_f a,
165: per_people_f p,
166: pay_payroll_actions pa,
167: pay_payroll_actions ppa,
168: pay_assignment_actions ppac
169: where pa.payroll_action_id = c_payroll_action_id
170: and p.person_id between c_start_person_id and c_end_person_id
171: and p.person_id = a.person_id
172: and p.business_group_id = pa.business_group_id

Line 186: from pay_assignment_actions ppac1,

182: FROM pay_action_interlocks pail
183: WHERE pail.locked_action_id=ppac.assignment_action_id)
184: and ppac.assignment_action_id in
185: (select max(ppac1.assignment_action_id)
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) =

Line 221: pay_assignment_actions ppac

217: pay_population_ranges ppr,
218: pay_payroll_actions ppa,
219: per_people_f p,
220: per_assignments_f a,
221: pay_assignment_actions ppac
222: WHERE pa.payroll_action_id = c_payroll_action_id
223: AND ppr.payroll_action_id = pa.payroll_action_id
224: AND ppr.chunk_number = c_chunk
225: AND p.person_id = ppr.person_id

Line 244: FROM pay_assignment_actions ppac1,

240: FROM pay_action_interlocks pail
241: WHERE pail.locked_action_id = ppac.assignment_action_id)
242: AND ppac.assignment_action_id IN
243: (SELECT MAX(ppac1.assignment_action_id)
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) =

Line 260: select pay_assignment_actions_s.nextval

256:
257:
258:
259: cursor next_action_id is
260: select pay_assignment_actions_s.nextval
261: from dual;
262:
263:
264: /* Bug 6470581 - Added the Following cursors to get Payment Summary Information

Line 284: ,c_reg_emp IN pay_assignment_actions.tax_unit_id%TYPE

280: (c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
281: ,c_start_person_id IN per_all_people_f.person_id%TYPE
282: ,c_end_person_id IN per_all_people_f.person_id%TYPE
283: ,c_archive_id IN pay_payroll_actions.payroll_action_id%TYPE
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

Line 295: ,pay_assignment_actions ppac

291: FROM per_assignments_f a
292: ,per_people_f p
293: ,pay_payroll_actions pa
294: ,pay_payroll_actions ppa
295: ,pay_assignment_actions ppac
296: ,pay_assignment_actions pmaa
297: ,pay_payroll_actions pmpa
298: WHERE pa.payroll_action_id = c_payroll_action_id
299: AND p.person_id between c_start_person_id and c_end_person_id

Line 296: ,pay_assignment_actions pmaa

292: ,per_people_f p
293: ,pay_payroll_actions pa
294: ,pay_payroll_actions ppa
295: ,pay_assignment_actions ppac
296: ,pay_assignment_actions pmaa
297: ,pay_payroll_actions pmpa
298: WHERE pa.payroll_action_id = c_payroll_action_id
299: AND p.person_id between c_start_person_id and c_end_person_id
300: AND p.person_id = a.person_id

Line 327: FROM pay_assignment_actions ppac1,

323: FROM pay_action_interlocks pail
324: WHERE pail.locked_action_id=pmaa.assignment_action_id)
325: AND ppac.assignment_action_id IN
326: (SELECT MAX(ppac1.assignment_action_id)
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) =

Line 343: ,c_reg_emp IN pay_assignment_actions.tax_unit_id%TYPE

339: CURSOR rg_amend_process_assignments
340: (c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
341: ,c_chunk IN NUMBER
342: ,c_archive_id IN pay_payroll_actions.payroll_action_id%TYPE
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

Line 354: ,pay_assignment_actions ppac

350: FROM per_assignments_f a
351: ,per_people_f p
352: ,pay_payroll_actions pa
353: ,pay_payroll_actions ppa
354: ,pay_assignment_actions ppac
355: ,pay_assignment_actions pmaa
356: ,pay_payroll_actions pmpa
357: ,pay_population_ranges ppr
358: WHERE pa.payroll_action_id = c_payroll_action_id

Line 355: ,pay_assignment_actions pmaa

351: ,per_people_f p
352: ,pay_payroll_actions pa
353: ,pay_payroll_actions ppa
354: ,pay_assignment_actions ppac
355: ,pay_assignment_actions pmaa
356: ,pay_payroll_actions pmpa
357: ,pay_population_ranges ppr
358: WHERE pa.payroll_action_id = c_payroll_action_id
359: AND ppr.payroll_action_id = pa.payroll_action_id

Line 389: FROM pay_assignment_actions ppac1,

385: FROM pay_action_interlocks pail
386: WHERE pail.locked_action_id=pmaa.assignment_action_id)
387: AND ppac.assignment_action_id IN
388: (SELECT MAX(ppac1.assignment_action_id)
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) =

Line 609: pay_assignment_actions pac

605: cursor csr_is_assignemnt_exist (p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE) is
606: select count(ppav.assignment_id)
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