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_CA_EOY_T4_CANCEL_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 265: ln_agent_tax_unit_id pay_assignment_actions.tax_unit_id%type;

261: lv_sql_string VARCHAR2(32000);
262: ln_eoy_pactid number;
263: lv_print varchar2(10):=null;
264: lv_error_mesg varchar2(100);
265: ln_agent_tax_unit_id pay_assignment_actions.tax_unit_id%type;
266: ln_year number;
267: lv_prov_cd varchar2(5);
268: lv_report_type varchar2(50);
269:

Line 319: pay_assignment_actions paa_rep,

315:
316: lv_sql_string :=
317: 'select distinct paf.person_id
318: from pay_payroll_actions ppa_rep,
319: pay_assignment_actions paa_rep,
320: per_assignments_f paf,
321: pay_payroll_actions ppa
322: where paa_rep.assignment_id = paf.assignment_id
323: and ppa.payroll_action_id = :payroll_action_id

Line 338: pay_assignment_actions paa_rep,

334:
335: lv_sql_string :=
336: 'select distinct paf.person_id
337: from pay_payroll_actions ppa_rep,
338: pay_assignment_actions paa_rep,
339: per_assignments_f paf,
340: pay_payroll_actions ppa
341: where paa_rep.assignment_id = paf.assignment_id
342: and ppa.payroll_action_id = :payroll_action_id

Line 356: pay_assignment_actions paa_rep,

352:
353: lv_sql_string :=
354: 'select distinct paf.person_id
355: from pay_payroll_actions ppa_rep,
356: pay_assignment_actions paa_rep,
357: per_assignments_f paf,
358: pay_payroll_actions ppa
359: where paa_rep.assignment_id = paf.assignment_id
360: and ppa.payroll_action_id = :payroll_action_id

Line 374: pay_assignment_actions paa_rep,

370:
371: lv_sql_string :=
372: 'select distinct paf.person_id
373: from pay_payroll_actions ppa_rep,
374: pay_assignment_actions paa_rep,
375: per_assignments_f paf,
376: pay_payroll_actions ppa
377: where paa_rep.assignment_id = paf.assignment_id
378: and ppa.payroll_action_id = :payroll_action_id

Line 433: ln_rep_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;

429: lv_print varchar2(10);
430: lv_prov_cd varchar2(5);
431:
432: lv_report_type pay_payroll_actions.report_type%TYPE ;
433: ln_rep_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
434: ln_arch_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
435: ln_second_last_arch_action pay_assignment_actions.assignment_action_id%TYPE;
436: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;
437:

Line 434: ln_arch_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;

430: lv_prov_cd varchar2(5);
431:
432: lv_report_type pay_payroll_actions.report_type%TYPE ;
433: ln_rep_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
434: ln_arch_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
435: ln_second_last_arch_action pay_assignment_actions.assignment_action_id%TYPE;
436: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;
437:
438:

Line 435: ln_second_last_arch_action pay_assignment_actions.assignment_action_id%TYPE;

431:
432: lv_report_type pay_payroll_actions.report_type%TYPE ;
433: ln_rep_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
434: ln_arch_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
435: ln_second_last_arch_action pay_assignment_actions.assignment_action_id%TYPE;
436: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;
437:
438:
439: lv_serial_number VARCHAR2(30);

Line 436: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;

432: lv_report_type pay_payroll_actions.report_type%TYPE ;
433: ln_rep_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
434: ln_arch_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
435: ln_second_last_arch_action pay_assignment_actions.assignment_action_id%TYPE;
436: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;
437:
438:
439: lv_serial_number VARCHAR2(30);
440: lv_employee_number per_people_f.employee_number%type;

Line 445: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;

441: lv_message varchar2(240):= null;
442: lv_full_name per_people_f.full_name%type;
443: lv_record_name varchar2(100);
444: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
445: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
446: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;
447: ln_serial_number pay_assignment_actions.serial_number%TYPE;
448: ln_gre_id NUMBER;
449: ln_gre_parameter NUMBER;

Line 446: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;

442: lv_full_name per_people_f.full_name%type;
443: lv_record_name varchar2(100);
444: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
445: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
446: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;
447: ln_serial_number pay_assignment_actions.serial_number%TYPE;
448: ln_gre_id NUMBER;
449: ln_gre_parameter NUMBER;
450: lv_ppr_report_type varchar2(50);

Line 447: ln_serial_number pay_assignment_actions.serial_number%TYPE;

443: lv_record_name varchar2(100);
444: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
445: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
446: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;
447: ln_serial_number pay_assignment_actions.serial_number%TYPE;
448: ln_gre_id NUMBER;
449: ln_gre_parameter NUMBER;
450: lv_ppr_report_type varchar2(50);
451: -- Variables declared for bug 10399514

Line 468: pay_assignment_actions paa

464: select distinct paf.person_id
465: from hr_assignment_set_amendments asgset,
466: per_assignments_f paf,
467: pay_payroll_actions ppa,
468: pay_assignment_actions paa
469: where asgset.assignment_set_id = cp_asg_set
470: and asgset.include_or_exclude = 'I'
471: and paf.assignment_id = asgset.assignment_id
472: and paf.person_id between cp_start_person

Line 492: pay_assignment_actions paa,

488: select distinct paf.person_id
489: from hr_assignment_set_amendments asgset,
490: per_assignments_f paf,
491: pay_payroll_actions ppa,
492: pay_assignment_actions paa,
493: pay_population_ranges ppr
494: where asgset.assignment_set_id = cp_asg_set
495: and asgset.include_or_exclude = 'I'
496: and paf.assignment_id = asgset.assignment_id

Line 525: pay_assignment_actions paa

521: AND hoi.org_information_context = 'Canada Employer Identification'
522: AND hoi.org_information5 = 'T4/RL1'
523: AND exists ( SELECT 1
524: FROM pay_payroll_actions ppa ,
525: pay_assignment_actions paa
526: WHERE ppa.report_type in ('T4_XML','PAYCAT4AMPDF')
527: AND ppa.report_qualifier = 'DEFAULT'
528: AND ppa.business_group_id = cp_bg_id
529: AND ppa.effective_date = cp_eff_date

Line 540: pay_assignment_actions paa_rep,

536: cp_start_person number,
537: cp_end_person number) is
538: select distinct paf.person_id
539: from pay_payroll_actions ppa_rep,
540: pay_assignment_actions paa_rep,
541: per_assignments_f paf
542: where ppa_rep.business_group_id = cp_bg_id
543: and ppa_rep.report_type in ('T4_XML','PAYCAT4AMPDF')
544: and ppa_rep.report_qualifier = 'DEFAULT'

Line 564: pay_assignment_actions paa_rep,

560: cp_start_person number,
561: cp_end_person number) is
562: select distinct paf.person_id
563: from pay_payroll_actions ppa_rep,
564: pay_assignment_actions paa_rep,
565: per_assignments_f paf,
566: pay_population_ranges ppr
567: where ppa_rep.business_group_id = cp_bg_id
568: and ppa_rep.report_type in ('T4_XML','PAYCAT4AMPDF')

Line 595: pay_assignment_actions paa,

591: paa.tax_unit_id,
592: paa.serial_number,
593: paf.effective_end_date
594: from pay_payroll_actions ppa,
595: pay_assignment_actions paa,
596: per_assignments_f paf
597: where paf.person_id = to_char(cp_person_id)
598: and paf.assignment_id = paa.assignment_id
599: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)

Line 616: pay_assignment_actions paa1,

612: and paf.effective_start_date <= cp_effective_date
613: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
614: and not exists (select 1
615: from pay_action_interlocks pai,
616: pay_assignment_actions paa1,
617: pay_payroll_actions ppa1
618: where pai.locked_action_id = paa.assignment_action_id
619: and pai.locking_action_id = paa1.assignment_action_id
620: and ppa1.effective_date = ppa.effective_date

Line 625: from pay_assignment_actions paa2,

621: and paa1.tax_unit_id = paa.tax_unit_id
622: and paa1.payroll_action_id = ppa1.payroll_action_id
623: and ppa1.report_type = 'PAYCAT4CLPDF')
624: and not exists (select 1
625: from pay_assignment_actions paa2,
626: pay_payroll_actions ppa2
627: where paa2.payroll_action_id = ppa2.payroll_action_id
628: and ppa2.report_type in ('T4_XML','PAYCAT4AMPDF')
629: and ppa2.effective_date = ppa.effective_date

Line 649: pay_assignment_actions paa,

645: paa.tax_unit_id,
646: paa.serial_number,
647: paf.effective_end_date
648: from pay_payroll_actions ppa,
649: pay_assignment_actions paa,
650: per_assignments_f paf
651: where paf.person_id = to_char(cp_person_id)
652: and paf.assignment_id = paa.assignment_id
653: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)

Line 669: pay_assignment_actions paa1

665: and exists
666: ( SELECT pail.locked_action_id
667: FROM pay_action_interlocks pail,
668: pay_payroll_actions ppa1,
669: pay_assignment_actions paa1
670: WHERE ppa1.report_type = 'PAYCAT4CLPDF'
671: AND ppa1.payroll_action_id = paa1.payroll_action_id
672: AND ppa1.effective_date = cp_effective_date
673: AND paa1.assignment_action_id = pail.locking_action_id

Line 679: from pay_assignment_actions paa2,

675: AND paa1.assignment_id=paf.assignment_id
676: AND pail.locked_action_id = paa.assignment_action_id)
677: and not exists
678: (select 1
679: from pay_assignment_actions paa2,
680: pay_payroll_actions ppa2
681: where paa2.payroll_action_id = ppa2.payroll_action_id
682: and ppa2.report_type in ('T4_XML','PAYCAT4AMPDF')
683: and ppa2.effective_date = ppa.effective_date

Line 705: pay_assignment_actions paa,

701: paa.tax_unit_id,
702: paa.serial_number,
703: paf.effective_end_date
704: from pay_payroll_actions ppa,
705: pay_assignment_actions paa,
706: per_assignments_f paf,
707: per_periods_of_service PDS
708: where paf.person_id = to_char(cp_person_id)
709: and paf.assignment_id = paa.assignment_id

Line 727: pay_assignment_actions paa1,

723: and paf.effective_start_date <= cp_effective_date
724: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
725: and not exists (select 1
726: from pay_action_interlocks pai,
727: pay_assignment_actions paa1,
728: pay_payroll_actions ppa1
729: where pai.locked_action_id = paa.assignment_action_id
730: and pai.locking_action_id = paa1.assignment_action_id
731: and ppa1.effective_date = ppa.effective_date

Line 736: from pay_assignment_actions paa2,

732: and paa1.tax_unit_id = paa.tax_unit_id
733: and paa1.payroll_action_id = ppa1.payroll_action_id
734: and ppa1.report_type = 'PAYCAT4CLPDF')
735: and not exists (select 1
736: from pay_assignment_actions paa2,
737: pay_payroll_actions ppa2
738: where paa2.payroll_action_id = ppa2.payroll_action_id
739: and ppa2.report_type in ('T4_XML','PAYCAT4AMPDF')
740: and ppa2.effective_date = ppa.effective_date

Line 762: pay_assignment_actions paa,

758: paa.tax_unit_id,
759: paa.serial_number,
760: paf.effective_end_date
761: from pay_payroll_actions ppa,
762: pay_assignment_actions paa,
763: per_assignments_f paf,
764: per_periods_of_service PDS
765: where paf.person_id = to_char(cp_person_id)
766: and paf.assignment_id = paa.assignment_id

Line 783: pay_assignment_actions paa1

779: and exists
780: ( SELECT pail.locked_action_id
781: FROM pay_action_interlocks pail,
782: pay_payroll_actions ppa1,
783: pay_assignment_actions paa1
784: WHERE ppa1.report_type = 'PAYCAT4CLPDF'
785: AND ppa1.payroll_action_id = paa1.payroll_action_id
786: AND ppa1.effective_date = cp_effective_date
787: AND paa1.assignment_action_id = pail.locking_action_id

Line 793: from pay_assignment_actions paa2,

789: AND paa1.assignment_id=paf.assignment_id
790: AND pail.locked_action_id = paa.assignment_action_id)
791: and not exists
792: (select 1
793: from pay_assignment_actions paa2,
794: pay_payroll_actions ppa2
795: where paa2.payroll_action_id = ppa2.payroll_action_id
796: and ppa2.report_type in ('T4_XML','PAYCAT4AMPDF')
797: and ppa2.effective_date = ppa.effective_date

Line 810: CURSOR check_arch_action_exists (p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) is

806: group by paa.assignment_action_id,ppa.report_type,paa.assignment_id,paa.tax_unit_id,paa.serial_number,paf.effective_end_date
807: order by paa.assignment_action_id desc;
808: -- Changes for bug 15886428 ends
809:
810: CURSOR check_arch_action_exists (p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) is
811: select 'Y'
812: from pay_assignment_actions
813: where assignment_action_id = p_assignment_action_id;
814:

Line 812: from pay_assignment_actions

808: -- Changes for bug 15886428 ends
809:
810: CURSOR check_arch_action_exists (p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) is
811: select 'Y'
812: from pay_assignment_actions
813: where assignment_action_id = p_assignment_action_id;
814:
815: CURSOR get_warning_dtls_for_ee(cp_person_id in number) is
816: select substr(full_name,1,48), employee_number

Line 831: lv_serial_number pay_assignment_actions.serial_number%TYPE;

827: ln_yepp_pact_id number;
828: ln_gre_id_null number;
829: ln_iteration number :=0;
830: lv_flag_count number :=0;
831: lv_serial_number pay_assignment_actions.serial_number%TYPE;
832: l_arch_action_exists varchar2(2);
833:
834: lv_negative_bal_flag varchar2(10);
835: lv_neg_bal_mesg varchar2(100);

Line 960: select pay_assignment_actions_s.nextval

956: 'PRINT',
957: 'ASSIGNMENT',
958: ln_primary_assignment_id,
959: l_effective_end_date),'Y') = 'Y' then
960: select pay_assignment_actions_s.nextval
961: into ln_t4cancel_asg_action
962: from dual;
963:
964: hr_utility.trace('New T4 Cancel Action = ' ||

Line 967: /* Insert into pay_assignment_actions. */

963:
964: hr_utility.trace('New T4 Cancel Action = ' ||
965: to_char(ln_t4cancel_asg_action));
966:
967: /* Insert into pay_assignment_actions. */
968: hr_nonrun_asact.insact(ln_t4cancel_asg_action
969: ,ln_primary_assignment_id
970: ,p_payroll_action_id
971: ,p_chunk

Line 988: update pay_assignment_actions aa

984: ln_serial_number := lv_prov_of_emp||
985: lpad(to_char(ln_rep_act_to_lock),14,0)||
986: lpad(to_char(ln_arch_act_to_lock),14,0);
987:
988: update pay_assignment_actions aa
989: set aa.serial_number = ln_serial_number
990: where aa.assignment_action_id = ln_t4cancel_asg_action;
991:
992: hr_utility.trace('lv_prov_of_emp :'||substr(ln_serial_number,1,2));

Line 1103: select pay_assignment_actions_s.nextval

1099: 'ASSIGNMENT',
1100: ln_primary_assignment_id,
1101: l_effective_end_date),'Y') = 'Y' then
1102:
1103: select pay_assignment_actions_s.nextval
1104: into ln_t4cancel_asg_action
1105: from dual;
1106:
1107: hr_utility.trace('New T4 Cancel Action = ' ||

Line 1110: /* Insert into pay_assignment_actions. */

1106:
1107: hr_utility.trace('New T4 Cancel Action = ' ||
1108: to_char(ln_t4cancel_asg_action));
1109:
1110: /* Insert into pay_assignment_actions. */
1111: hr_nonrun_asact.insact(ln_t4cancel_asg_action
1112: ,ln_primary_assignment_id
1113: ,p_payroll_action_id
1114: ,p_chunk

Line 1131: update pay_assignment_actions aa

1127: ln_serial_number := lv_prov_of_emp||
1128: lpad(to_char(ln_rep_act_to_lock),14,0)||
1129: lpad(to_char(ln_arch_act_to_lock),14,0);
1130:
1131: update pay_assignment_actions aa
1132: set aa.serial_number = ln_serial_number
1133: where aa.assignment_action_id = ln_t4cancel_asg_action;
1134: hr_utility.trace('lv_prov_of_emp :'||substr(ln_serial_number,1,2));
1135: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));

Line 1405: l_gre_id pay_assignment_actions.tax_unit_id%type;

1401: ) is
1402:
1403: l_dt date;
1404: l_year number ;
1405: l_gre_id pay_assignment_actions.tax_unit_id%type;
1406: l_per_id per_assignments_f.person_id%type;
1407: l_sort1 varchar2(60);
1408: l_sort2 varchar2(60);
1409: l_sort3 varchar2(60);

Line 1462: pay_assignment_actions paa1,

1458: hr_all_organization_units hou1,
1459: hr_locations_all loc,
1460: per_all_people_f ppf,
1461: per_all_assignments_f paf,
1462: pay_assignment_actions paa1,
1463: pay_payroll_actions ppa1
1464: where ppa1.payroll_action_id = :p_payroll_action_id
1465: and paa1.payroll_action_id = ppa1.payroll_action_id
1466: and paa1.assignment_id = paf.assignment_id