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_PAYROLL_ACTIONS

Line 49: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

45: -- of assignments eligible for archive report process.
46: -------------------------------------------------------------------------
47:
48: procedure range_code
49: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
50: p_sql out NOCOPY varchar2) is
51: begin
52: hr_utility.set_location('Start of range_code',1);
53:

Line 58: ' pay_payroll_actions pa' ||

54: /*Bug2920725 Corrected base tables to support security model*/
55:
56: p_sql := ' select distinct p.person_id' ||
57: ' from per_people_f p,' ||
58: ' pay_payroll_actions pa' ||
59: ' where pa.payroll_action_id = :payroll_action_id' ||
60: ' and p.business_group_id = pa.business_group_id' ||
61: ' order by p.person_id';
62:

Line 147: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

143: -- the cursor to select assignment action selects assignment id for which
144: -- archival has been done.
145:
146: procedure assignment_action_code
147: (p_payroll_action_id in pay_payroll_actions.payroll_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:

Line 158: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

154: /*Bug2920725 Corrected base tables to support security model*/
155:
156:
157: cursor process_assignments
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,

Line 166: pay_payroll_actions pa,

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,
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

Line 167: pay_payroll_actions ppa,

163: ppac.assignment_action_id
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

Line 187: pay_payroll_Actions ppaa

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) =
191: pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pa.legislative_parameters) --2610141

Line 209: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

205: */
206:
207:
208: CURSOR range_process_assignments
209: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
210: c_chunk in NUMBER)
211: IS
212: SELECT /*+ ORDERED */
213: DISTINCT a.assignment_id,

Line 216: FROM pay_payroll_actions pa,

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,
219: per_people_f p,
220: per_assignments_f a,

Line 218: pay_payroll_actions ppa,

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,
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

Line 245: pay_payroll_Actions ppaa

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) =
249: pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pa.legislative_parameters)

Line 269: (c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)

265: and asignments eligible for Self Printed process for Amended PS
266: */
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

Line 275: FROM pay_payroll_actions ppa

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:
279: CURSOR c_amend_process_assignments

Line 280: (c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE

276: WHERE ppa.payroll_action_id = c_payroll_action_id;
277:
278:
279: CURSOR c_amend_process_assignments
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

Line 283: ,c_archive_id IN pay_payroll_actions.payroll_action_id%TYPE

279: CURSOR c_amend_process_assignments
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

Line 293: ,pay_payroll_actions pa

289: ,ppac.assignment_action_id
290: ,pmaa.assignment_action_id datafile_action_id
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

Line 294: ,pay_payroll_actions ppa

290: ,pmaa.assignment_action_id datafile_action_id
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

Line 297: ,pay_payroll_actions pmpa

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
301: AND p.business_group_id = pa.business_group_id

Line 328: pay_payroll_Actions ppaa

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) =
332: pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pa.legislative_parameters) --2610141

Line 340: (c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE

336:
337: /* 9113084 - Added new cursor for above cursor c_amend_process_assignments */
338: /* 9113084 - Cursor to fetch assignments for Self Printed Amended Payment Summary when RANGE_PERSON_ID is enabled */
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)

Line 342: ,c_archive_id IN pay_payroll_actions.payroll_action_id%TYPE

338: /* 9113084 - Cursor to fetch assignments for Self Printed Amended Payment Summary when RANGE_PERSON_ID is enabled */
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

Line 352: ,pay_payroll_actions pa

348: ,ppac.assignment_action_id
349: ,pmaa.assignment_action_id datafile_action_id
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

Line 353: ,pay_payroll_actions ppa

349: ,pmaa.assignment_action_id datafile_action_id
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

Line 356: ,pay_payroll_actions pmpa

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
360: AND ppr.chunk_number = c_chunk

Line 390: pay_payroll_Actions ppaa

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) =
394: pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pa.legislative_parameters)

Line 559: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

555: is
556: l_count number :=0;
557: ps_request_id NUMBER;
558: l_formula_id ff_formulas_f.formula_id%TYPE;
559: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
560: l_sort_order1 varchar2(40);
561: l_sort_order2 varchar2(40):=null;
562: l_sort_order3 varchar2(40):=null;
563: l_sort_order4 varchar2(40):=null;

Line 566: l_current_chunk_number pay_payroll_actions.current_chunk_number%TYPE;

562: l_sort_order3 varchar2(40):=null;
563: l_sort_order4 varchar2(40):=null;
564: l_passed_sort_order varchar2(40);
565: l_print_style VARCHAR2(2);
566: l_current_chunk_number pay_payroll_actions.current_chunk_number%TYPE;
567: l_print_together VARCHAR2(80);
568: l_print_return BOOLEAN;
569: l_duplex_print_flag varchar2(2);
570: l_template_name varchar2(80); -- Bug 4859876

Line 577: from pay_payroll_actions p

573:
574:
575: cursor csr_get_current_chunk_number(p_payroll_action_id number) is
576: select p.current_chunk_number
577: from pay_payroll_actions p
578: where payroll_action_id = p_payroll_action_id;
579:
580:
581: cursor csr_get_formula_id(p_formula_name VARCHAR2) IS

Line 597: FROM pay_payroll_actions pact,

593: SELECT printer,
594: print_style,
595: decode(save_output_flag, 'Y', 'TRUE', 'N', 'FALSE') save_output,
596: number_of_copies /* Bug: 3768288 */
597: FROM pay_payroll_actions pact,
598: fnd_concurrent_requests fcr
599: WHERE fcr.request_id = pact.request_id
600: AND pact.payroll_action_id = p_payroll_action_id;
601:

Line 605: cursor csr_is_assignemnt_exist (p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE) is

601:
602: /*Bug# 5743270
603: Cursor checks whether any assignment exist for which Printed Payment Summary(PUI) need to be produced
604: */
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

Line 608: pay_payroll_actions ppa,

604: */
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'