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_REC_DET_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 83: g_arc_payroll_action_id pay_payroll_actions.payroll_action_id%type;

79: ***21-Mar-08 avenkatk 115.49 6839263 Added Logic to set the OPP Template options for PDF output
80: *** ------------------------------------------------------------------------+
81: */
82:
83: g_arc_payroll_action_id pay_payroll_actions.payroll_action_id%type;
84: g_business_group_id hr_all_organization_units.organization_id%type;
85: g_prev_assignment_id number;
86: g_def_bal_populted varchar2(1);
87:

Line 104: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type

100: --
101: --------------------------------------------------------------------
102:
103: procedure range_code
104: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
105: ,p_sql out NOCOPY varchar2
106: ) is
107:
108: l_procedure varchar2(200) ;

Line 123: ' pay_payroll_actions pa' ||

119: -- Archive the payroll action level data and EIT defintions.
120: -- sql string to SELECT a range of assignments eligible for archival.
121: p_sql := ' select distinct p.person_id' ||
122: ' from per_people_f p,' ||
123: ' pay_payroll_actions pa' ||
124: ' where pa.payroll_action_id = :payroll_action_id' ||
125: ' and p.business_group_id = pa.business_group_id' ||
126: ' order by p.person_id';
127:

Line 169: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)

165: -- This procedure is used to set global contexts
166: --------------------------------------------------------------------+
167:
168: procedure initialization_code
169: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)
170: is
171: l_procedure varchar2(200) ;
172:
173: /*Bug 4132149 - Modification begins here*/

Line 180: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)

176: -- Description : Fetches User Parameters from Legislative_paramters
177: -- column.
178: --------------------------------------------------------------------+
179:
180: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
181: IS
182: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
183: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
184: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,

Line 200: FROM pay_payroll_actions ppa

196: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
197: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
198: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
199: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
200: FROM pay_payroll_actions ppa
201: WHERE ppa.payroll_action_id = c_payroll_action_id;
202:
203: --------------------------------------------------------------------+
204: -- Cursor : csr_period_date_earned

Line 208: CURSOR csr_period_date_earned(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)

204: -- Cursor : csr_period_date_earned
205: -- Description : Fetches Date Earned for a given payroll
206: -- run.
207: --------------------------------------------------------------------+
208: CURSOR csr_period_date_earned(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
209: IS
210: SELECT ppa.date_earned
211: FROM pay_payroll_actions ppa
212: WHERE

Line 211: FROM pay_payroll_actions ppa

207: --------------------------------------------------------------------+
208: CURSOR csr_period_date_earned(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
209: IS
210: SELECT ppa.date_earned
211: FROM pay_payroll_actions ppa
212: WHERE
213: ppa.payroll_action_id = c_payroll_action_id;
214:
215: /*Bug 4132149 - Modification ends here*/

Line 313: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type

309: -- Depending on the parameters passed,the appropriate cursor is used.
310: --------------------------------------------------------------------+
311:
312: procedure assignment_action_code
313: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
314: ,p_start_person in per_all_people_f.person_id%type
315: ,p_end_person in per_all_people_f.person_id%type
316: ,p_chunk in number
317: ) is

Line 326: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type

322: -- Start Date and End Date is specified
323: --------------------------------------------------------------------+
324:
325: cursor csr_assignment_org_period
326: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
327: ,c_start_person per_all_people_f.person_id%type
328: ,c_end_person per_all_people_f.person_id%type
329: ,c_employee_type per_all_people_f.current_employee_flag%type
330: ,c_business_group_id hr_all_organization_units.organization_id%type

Line 341: pay_payroll_actions ppa,

337: paaf.assignment_id,
338: paa.tax_unit_id
339: from per_people_f pap,
340: per_assignments_f paaf,
341: pay_payroll_actions ppa,
342: pay_payroll_actions ppa1,
343: pay_assignment_actions paa,
344: hr_organization_units hou,
345: per_periods_of_service pps

Line 342: pay_payroll_actions ppa1,

338: paa.tax_unit_id
339: from per_people_f pap,
340: per_assignments_f paaf,
341: pay_payroll_actions ppa,
342: pay_payroll_actions ppa1,
343: pay_assignment_actions paa,
344: hr_organization_units hou,
345: per_periods_of_service pps
346: -- ,per_assignment_status_types past

Line 379: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type

375: -- and Period End Date is specified
376: --------------------------------------------------------------------+
377:
378: cursor csr_assignment_org_run
379: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
380: ,c_start_person per_all_people_f.person_id%type
381: ,c_end_person per_all_people_f.person_id%type
382: ,c_employee_type per_all_people_f.current_employee_flag%type
383: ,c_business_group_id hr_all_organization_units.organization_id%type

Line 386: ,c_pact_id pay_payroll_actions.payroll_action_id%type

382: ,c_employee_type per_all_people_f.current_employee_flag%type
383: ,c_business_group_id hr_all_organization_units.organization_id%type
384: ,c_organization_id hr_all_organization_units.organization_id%type
385: ,c_period_end_date date
386: ,c_pact_id pay_payroll_actions.payroll_action_id%type
387: ) is
388: select paa.assignment_action_id,
389: paa.action_sequence,
390: paaf.assignment_id,

Line 394: pay_payroll_actions ppa,

390: paaf.assignment_id,
391: paa.tax_unit_id
392: from per_people_f pap,
393: per_assignments_f paaf,
394: pay_payroll_actions ppa,
395: pay_payroll_actions ppa1,
396: pay_assignment_actions paa,
397: hr_organization_units hou,
398: per_periods_of_service pps

Line 395: pay_payroll_actions ppa1,

391: paa.tax_unit_id
392: from per_people_f pap,
393: per_assignments_f paaf,
394: pay_payroll_actions ppa,
395: pay_payroll_actions ppa1,
396: pay_assignment_actions paa,
397: hr_organization_units hou,
398: per_periods_of_service pps
399: where ppa.payroll_action_id = c_payroll_action_id

Line 426: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type

422: -- Start Date and End Date is specified
423: --------------------------------------------------------------------+
424:
425: cursor csr_assignment_legal_period
426: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
427: ,c_start_person per_all_people_f.person_id%type
428: ,c_end_person per_all_people_f.person_id%type
429: ,c_employee_type per_all_people_f.current_employee_flag%type
430: ,c_business_group_id hr_all_organization_units.organization_id%type

Line 441: pay_payroll_actions ppa,

437: paaf.assignment_id,
438: paa.tax_unit_id
439: from per_people_f pap,
440: per_assignments_f paaf,
441: pay_payroll_actions ppa,
442: pay_payroll_actions ppa1,
443: pay_assignment_actions paa,
444: per_periods_of_service pps
445: -- ,per_assignment_status_types past

Line 442: pay_payroll_actions ppa1,

438: paa.tax_unit_id
439: from per_people_f pap,
440: per_assignments_f paaf,
441: pay_payroll_actions ppa,
442: pay_payroll_actions ppa1,
443: pay_assignment_actions paa,
444: per_periods_of_service pps
445: -- ,per_assignment_status_types past
446: where ppa.payroll_action_id = c_payroll_action_id

Line 477: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type

473: --------------------------------------------------------------------+
474:
475:
476: cursor csr_assignment_legal_run
477: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
478: ,c_start_person per_all_people_f.person_id%type
479: ,c_end_person per_all_people_f.person_id%type
480: ,c_employee_type per_all_people_f.current_employee_flag%type
481: ,c_business_group_id hr_all_organization_units.organization_id%type

Line 484: ,c_pact_id pay_payroll_actions.payroll_action_id%type

480: ,c_employee_type per_all_people_f.current_employee_flag%type
481: ,c_business_group_id hr_all_organization_units.organization_id%type
482: ,c_legal_employer hr_all_organization_units.organization_id%type
483: ,c_period_end_date date
484: ,c_pact_id pay_payroll_actions.payroll_action_id%type
485: ) is
486: select paa.assignment_action_id,
487: paa.action_sequence,
488: paaf.assignment_id,

Line 492: pay_payroll_actions ppa,

488: paaf.assignment_id,
489: paa.tax_unit_id
490: from per_people_f pap,
491: per_assignments_f paaf,
492: pay_payroll_actions ppa,
493: pay_payroll_actions ppa1,
494: pay_assignment_actions paa,
495: per_periods_of_service pps
496: where ppa.payroll_action_id = c_payroll_action_id

Line 493: pay_payroll_actions ppa1,

489: paa.tax_unit_id
490: from per_people_f pap,
491: per_assignments_f paaf,
492: pay_payroll_actions ppa,
493: pay_payroll_actions ppa1,
494: pay_assignment_actions paa,
495: per_periods_of_service pps
496: where ppa.payroll_action_id = c_payroll_action_id
497: and paa.assignment_id = paaf.assignment_id

Line 521: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type

517: -- Date and End Date is specified
518: --------------------------------------------------------------------+
519:
520: cursor csr_assignment_payroll_period
521: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
522: ,c_start_person per_all_people_f.person_id%type
523: ,c_end_person per_all_people_f.person_id%type
524: ,c_employee_type per_all_people_f.current_employee_flag%type
525: ,c_business_group_id hr_all_organization_units.organization_id%type

Line 526: ,c_payroll_id pay_payroll_actions.payroll_id%type

522: ,c_start_person per_all_people_f.person_id%type
523: ,c_end_person per_all_people_f.person_id%type
524: ,c_employee_type per_all_people_f.current_employee_flag%type
525: ,c_business_group_id hr_all_organization_units.organization_id%type
526: ,c_payroll_id pay_payroll_actions.payroll_id%type
527: ,c_archive_start_date date
528: ,c_archive_end_date date
529: ) is
530: select paa.assignment_action_id,

Line 536: pay_payroll_actions ppa,

532: paaf.assignment_id,
533: paa.tax_unit_id
534: from per_people_f pap,
535: per_assignments_f paaf,
536: pay_payroll_actions ppa,
537: pay_payroll_actions ppa1,
538: pay_assignment_actions paa,
539: per_periods_of_service pps
540: -- per_assignment_status_types past

Line 537: pay_payroll_actions ppa1,

533: paa.tax_unit_id
534: from per_people_f pap,
535: per_assignments_f paaf,
536: pay_payroll_actions ppa,
537: pay_payroll_actions ppa1,
538: pay_assignment_actions paa,
539: per_periods_of_service pps
540: -- per_assignment_status_types past
541: where ppa.payroll_action_id = c_payroll_action_id

Line 571: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type

567: -- and Period End Date is specified
568: --------------------------------------------------------------------+
569:
570: cursor csr_assignment_payroll_run
571: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
572: ,c_start_person per_all_people_f.person_id%type
573: ,c_end_person per_all_people_f.person_id%type
574: ,c_employee_type per_all_people_f.current_employee_flag%type
575: ,c_business_group_id hr_all_organization_units.organization_id%type

Line 576: ,c_payroll_id pay_payroll_actions.payroll_id%type

572: ,c_start_person per_all_people_f.person_id%type
573: ,c_end_person per_all_people_f.person_id%type
574: ,c_employee_type per_all_people_f.current_employee_flag%type
575: ,c_business_group_id hr_all_organization_units.organization_id%type
576: ,c_payroll_id pay_payroll_actions.payroll_id%type
577: ,c_period_end_date date
578: ,c_pact_id pay_payroll_actions.payroll_action_id%type
579: ) is
580: select paa.assignment_action_id,

Line 578: ,c_pact_id pay_payroll_actions.payroll_action_id%type

574: ,c_employee_type per_all_people_f.current_employee_flag%type
575: ,c_business_group_id hr_all_organization_units.organization_id%type
576: ,c_payroll_id pay_payroll_actions.payroll_id%type
577: ,c_period_end_date date
578: ,c_pact_id pay_payroll_actions.payroll_action_id%type
579: ) is
580: select paa.assignment_action_id,
581: paa.action_sequence,
582: paaf.assignment_id,

Line 586: pay_payroll_actions ppa,

582: paaf.assignment_id,
583: paa.tax_unit_id
584: from per_people_f pap,
585: per_assignments_f paaf,
586: pay_payroll_actions ppa,
587: pay_payroll_actions ppa1,
588: pay_assignment_actions paa,
589: per_periods_of_service pps
590: where ppa.payroll_action_id = c_payroll_action_id

Line 587: pay_payroll_actions ppa1,

583: paa.tax_unit_id
584: from per_people_f pap,
585: per_assignments_f paaf,
586: pay_payroll_actions ppa,
587: pay_payroll_actions ppa1,
588: pay_assignment_actions paa,
589: per_periods_of_service pps
590: where ppa.payroll_action_id = c_payroll_action_id
591: and paa.assignment_id = paaf.assignment_id

Line 616: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type

612: -- Date and End Date is specified
613: --------------------------------------------------------------------+
614:
615: cursor csr_assignment_period
616: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
617: ,c_start_person per_all_people_f.person_id%type
618: ,c_end_person per_all_people_f.person_id%type
619: ,c_employee_type per_all_people_f.current_employee_flag%type
620: ,c_business_group_id hr_all_organization_units.organization_id%type

Line 631: pay_payroll_actions ppa,

627: paaf.assignment_id,
628: paa.tax_unit_id
629: from per_people_f pap,
630: per_assignments_f paaf,
631: pay_payroll_actions ppa,
632: pay_payroll_actions ppa1,
633: pay_assignment_actions paa,
634: per_periods_of_service pps
635: -- ,per_assignment_status_types past

Line 632: pay_payroll_actions ppa1,

628: paa.tax_unit_id
629: from per_people_f pap,
630: per_assignments_f paaf,
631: pay_payroll_actions ppa,
632: pay_payroll_actions ppa1,
633: pay_assignment_actions paa,
634: per_periods_of_service pps
635: -- ,per_assignment_status_types past
636: where ppa.payroll_action_id = c_payroll_action_id

Line 665: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type

661: -- and Period End Date is specified
662: --------------------------------------------------------------------+
663:
664: cursor csr_assignment_run
665: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
666: ,c_start_person per_all_people_f.person_id%type
667: ,c_end_person per_all_people_f.person_id%type
668: ,c_employee_type per_all_people_f.current_employee_flag%type
669: ,c_business_group_id hr_all_organization_units.organization_id%type

Line 672: ,c_pact_id pay_payroll_actions.payroll_action_id%type

668: ,c_employee_type per_all_people_f.current_employee_flag%type
669: ,c_business_group_id hr_all_organization_units.organization_id%type
670: ,c_assignment_id per_all_assignments_f.assignment_id%type
671: ,c_period_end_date date
672: ,c_pact_id pay_payroll_actions.payroll_action_id%type
673: ) is
674: select paa.assignment_action_id,
675: paa.action_sequence,
676: paaf.assignment_id,

Line 680: pay_payroll_actions ppa,

676: paaf.assignment_id,
677: paa.tax_unit_id
678: from per_people_f pap,
679: per_assignments_f paaf,
680: pay_payroll_actions ppa,
681: pay_payroll_actions ppa1,
682: pay_assignment_actions paa,
683: per_periods_of_service pps
684: where ppa.payroll_action_id = c_payroll_action_id

Line 681: pay_payroll_actions ppa1,

677: paa.tax_unit_id
678: from per_people_f pap,
679: per_assignments_f paaf,
680: pay_payroll_actions ppa,
681: pay_payroll_actions ppa1,
682: pay_assignment_actions paa,
683: per_periods_of_service pps
684: where ppa.payroll_action_id = c_payroll_action_id
685: and paa.assignment_id = paaf.assignment_id

Line 709: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type

705: -- and End Date is specified
706: --------------------------------------------------------------------+
707:
708: cursor csr_assignment_default_period
709: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
710: ,c_start_person per_all_people_f.person_id%type
711: ,c_end_person per_all_people_f.person_id%type
712: ,c_employee_type per_all_people_f.current_employee_flag%type
713: ,c_business_group_id hr_all_organization_units.organization_id%type

Line 723: pay_payroll_actions ppa,

719: paaf.assignment_id,
720: paa.tax_unit_id
721: from per_people_f pap,
722: per_assignments_f paaf,
723: pay_payroll_actions ppa,
724: pay_payroll_actions ppa1,
725: pay_assignment_actions paa,
726: per_periods_of_service pps
727: -- ,per_assignment_status_types past

Line 724: pay_payroll_actions ppa1,

720: paa.tax_unit_id
721: from per_people_f pap,
722: per_assignments_f paaf,
723: pay_payroll_actions ppa,
724: pay_payroll_actions ppa1,
725: pay_assignment_actions paa,
726: per_periods_of_service pps
727: -- ,per_assignment_status_types past
728: where ppa.payroll_action_id = c_payroll_action_id

Line 756: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type

752: -- and Period End Date is specified
753: --------------------------------------------------------------------+
754:
755: cursor csr_assignment_default_run
756: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
757: ,c_start_person per_all_people_f.person_id%type
758: ,c_end_person per_all_people_f.person_id%type
759: ,c_employee_type per_all_people_f.current_employee_flag%type
760: ,c_business_group_id hr_all_organization_units.organization_id%type

Line 762: ,c_pact_id pay_payroll_actions.payroll_action_id%type

758: ,c_end_person per_all_people_f.person_id%type
759: ,c_employee_type per_all_people_f.current_employee_flag%type
760: ,c_business_group_id hr_all_organization_units.organization_id%type
761: ,c_period_end_date date
762: ,c_pact_id pay_payroll_actions.payroll_action_id%type
763: ) is
764: select paa.assignment_action_id,
765: paa.action_sequence,
766: paaf.assignment_id,

Line 770: pay_payroll_actions ppa,

766: paaf.assignment_id,
767: paa.tax_unit_id
768: from per_people_f pap,
769: per_assignments_f paaf,
770: pay_payroll_actions ppa,
771: pay_payroll_actions ppa1,
772: pay_assignment_actions paa,
773: per_periods_of_service pps
774: where ppa.payroll_action_id = c_payroll_action_id

Line 771: pay_payroll_actions ppa1,

767: paa.tax_unit_id
768: from per_people_f pap,
769: per_assignments_f paaf,
770: pay_payroll_actions ppa,
771: pay_payroll_actions ppa1,
772: pay_assignment_actions paa,
773: per_periods_of_service pps
774: where ppa.payroll_action_id = c_payroll_action_id
775: and paa.assignment_id = paaf.assignment_id

Line 798: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)

794: -- Description : Fetches User Parameters from Legislative_paramters
795: -- column.
796: --------------------------------------------------------------------+
797:
798: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
799: IS
800: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
801: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
802: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,

Line 818: FROM pay_payroll_actions ppa

814: pay_core_utils.get_parameter('ZERO_REC',legislative_parameters) zero_records,
815: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
816: decode(pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters),'C','Y','T','N','%') employee_type,
817: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug# 4142159*/
818: FROM pay_payroll_actions ppa
819: WHERE ppa.payroll_action_id = c_payroll_action_id;
820:
821: --------------------------------------------------------------------+
822: -- Cursor : csr_period_date_earned

Line 827: CURSOR csr_period_date_earned(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)

823: -- Description : Fetches Date Earned for a given payroll
824: -- run.
825: --------------------------------------------------------------------+
826: /*Bug#3662449 *********/
827: CURSOR csr_period_date_earned(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
828: IS
829: SELECT ppa.date_earned
830: FROM pay_payroll_actions ppa
831: WHERE

Line 830: FROM pay_payroll_actions ppa

826: /*Bug#3662449 *********/
827: CURSOR csr_period_date_earned(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
828: IS
829: SELECT ppa.date_earned
830: FROM pay_payroll_actions ppa
831: WHERE
832: ppa.payroll_action_id = c_payroll_action_id;
833:
834:

Line 1546: ,p_effective_date in pay_payroll_actions.effective_date%type

1542: --------------------------------------------------------------------+
1543:
1544: procedure archive_code
1545: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
1546: ,p_effective_date in pay_payroll_actions.effective_date%type
1547: ) is
1548:
1549:
1550:

Line 1681: ,pay_payroll_actions ppa

1677: ,pay_input_values_f piv
1678: ,pay_element_classifications pec
1679: ,pay_assignment_actions paa
1680: ,pay_assignment_actions paa2 /*Bug 3935471*/
1681: ,pay_payroll_actions ppa
1682: ,per_assignments_f paaf
1683: ,pay_run_results prr
1684: ,pay_run_result_values prrv
1685: ,pay_element_classifications pec2

Line 1731: , pay_payroll_actions ppa

1727: is
1728: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
1729: ,max(paa.action_sequence)
1730: from pay_assignment_actions paa
1731: , pay_payroll_actions ppa
1732: , per_assignments_f paf
1733: where paa.assignment_id = paf.assignment_id
1734: and paf.assignment_id = c_assignment_id
1735: and ppa.payroll_action_id = paa.payroll_action_id

Line 1751: , pay_payroll_actions ppa

1747: is
1748: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
1749: ,max(paa.action_sequence)
1750: from pay_assignment_actions paa
1751: , pay_payroll_actions ppa
1752: , per_assignments_f paf
1753: where paa.assignment_id = paf.assignment_id
1754: and paf.assignment_id = c_assignment_id
1755: and ppa.payroll_action_id = paa.payroll_action_id

Line 2161: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)

2157:
2158:
2159:
2160: procedure spawn_archive_reports
2161: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)
2162: is
2163: l_count number;
2164: ps_request_id NUMBER;
2165: l_print_style VARCHAR2(2);

Line 2178: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)

2174: -- Description : Fetches User Parameters from Legislative_paramters
2175: -- column.
2176: --------------------------------------------------------------------+
2177:
2178: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
2179: IS
2180: SELECT pay_core_utils.get_parameter('PAY',legislative_parameters) payroll_id,
2181: pay_core_utils.get_parameter('ORG',legislative_parameters) org_id,
2182: pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,

Line 2199: FROM pay_payroll_actions ppa

2195: pay_core_utils.get_parameter('NEG_REC',legislative_parameters) negative_records,
2196: pay_core_utils.get_parameter('EMP_TYPE',legislative_parameters) employee_type,
2197: pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions, /*Bug# 4142159*/
2198: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters)p_output_type /* Bug# 6839263 */
2199: FROM pay_payroll_actions ppa
2200: WHERE ppa.payroll_action_id = c_payroll_action_id;
2201:
2202:
2203: cursor csr_get_print_options(p_payroll_action_id NUMBER) IS

Line 2208: FROM pay_payroll_actions pact,

2204: SELECT printer,
2205: print_style,
2206: decode(save_output_flag, 'Y', 'TRUE', 'N', 'FALSE') save_output
2207: ,number_of_copies /* Bug 4116833 */
2208: FROM pay_payroll_actions pact,
2209: fnd_concurrent_requests fcr
2210: WHERE fcr.request_id = pact.request_id
2211: AND pact.payroll_action_id = p_payroll_action_id;
2212:

Line 2372: p_effective_date IN pay_payroll_actions.effective_date%TYPE

2368: (
2369: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
2370: p_element_type_id IN pay_element_entries_f.element_entry_id%TYPE,
2371: p_run_result_id IN pay_run_results.run_result_ID%TYPE,
2372: p_effective_date IN pay_payroll_actions.effective_date%TYPE
2373: )
2374: RETURN NUMBER
2375: IS
2376:

Line 2454: p_effective_date IN pay_payroll_actions.effective_date%TYPE

2450: (
2451: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
2452: p_element_type_id IN pay_element_entries_f.element_entry_id%TYPE,
2453: p_run_result_id IN pay_run_results.run_result_ID%TYPE,
2454: p_effective_date IN pay_payroll_actions.effective_date%TYPE
2455: )
2456: RETURN NUMBER
2457: IS
2458: