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

Line 317: ln_agent_tax_unit_id pay_assignment_actions.tax_unit_id%type;

313: lv_sql_string VARCHAR2(32000);
314: ln_eoy_pactid number;
315: lv_print varchar2(10):=null;
316: lv_error_mesg varchar2(100);
317: ln_agent_tax_unit_id pay_assignment_actions.tax_unit_id%type;
318: ln_year number;
319: lv_prov_cd varchar2(5);
320: lv_report_type varchar2(50);
321:

Line 371: pay_assignment_actions paa_arch,

367:
368: lv_sql_string :=
369: 'select distinct paf.person_id
370: from pay_payroll_actions ppa_arch,
371: pay_assignment_actions paa_arch,
372: per_assignments_f paf,
373: pay_payroll_actions ppa
374: where paa_arch.assignment_id = paf.assignment_id
375: and ppa.payroll_action_id = :payroll_action_id

Line 389: pay_assignment_actions paa_arch,

385:
386: lv_sql_string :=
387: 'select distinct paf.person_id
388: from pay_payroll_actions ppa_arch,
389: pay_assignment_actions paa_arch,
390: per_assignments_f paf,
391: pay_payroll_actions ppa
392: where paa_arch.assignment_id = paf.assignment_id
393: and ppa.payroll_action_id = :payroll_action_id

Line 448: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;

444: lv_print varchar2(10);
445: lv_prov_cd varchar2(5);
446:
447: lv_report_type pay_payroll_actions.report_type%TYPE ;
448: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
449: ln_second_last_arch_action pay_assignment_actions.assignment_action_id%TYPE;
450: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;
451:
452:

Line 449: ln_second_last_arch_action pay_assignment_actions.assignment_action_id%TYPE;

445: lv_prov_cd varchar2(5);
446:
447: lv_report_type pay_payroll_actions.report_type%TYPE ;
448: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
449: ln_second_last_arch_action pay_assignment_actions.assignment_action_id%TYPE;
450: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;
451:
452:
453: lv_serial_number VARCHAR2(30);

Line 450: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;

446:
447: lv_report_type pay_payroll_actions.report_type%TYPE ;
448: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
449: ln_second_last_arch_action pay_assignment_actions.assignment_action_id%TYPE;
450: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;
451:
452:
453: lv_serial_number VARCHAR2(30);
454: lv_employee_number per_people_f.employee_number%type;

Line 459: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;

455: lv_message varchar2(240):= null; /*Increased size of variable for Bug#4676544*/
456: lv_full_name per_people_f.full_name%type;
457: lv_record_name varchar2(100);
458: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
459: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
460: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;
461: ln_serial_number pay_assignment_actions.serial_number%TYPE;
462: ln_gre_id NUMBER;
463: ln_gre_parameter NUMBER;

Line 460: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;

456: lv_full_name per_people_f.full_name%type;
457: lv_record_name varchar2(100);
458: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
459: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
460: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;
461: ln_serial_number pay_assignment_actions.serial_number%TYPE;
462: ln_gre_id NUMBER;
463: ln_gre_parameter NUMBER;
464: lv_ppr_report_type varchar2(50);

Line 461: ln_serial_number pay_assignment_actions.serial_number%TYPE;

457: lv_record_name varchar2(100);
458: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
459: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
460: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;
461: ln_serial_number pay_assignment_actions.serial_number%TYPE;
462: ln_gre_id NUMBER;
463: ln_gre_parameter NUMBER;
464: lv_ppr_report_type varchar2(50);
465:

Line 483: pay_assignment_actions paa

479: select distinct paf.person_id
480: from hr_assignment_set_amendments asgset,
481: per_assignments_f paf,
482: pay_payroll_actions ppa,
483: pay_assignment_actions paa
484: where asgset.assignment_set_id = cp_asg_set
485: and asgset.include_or_exclude = 'I'
486: and paf.assignment_id = asgset.assignment_id
487: and paf.person_id between cp_start_person

Line 507: pay_assignment_actions paa,

503: select distinct paf.person_id
504: from hr_assignment_set_amendments asgset,
505: per_assignments_f paf,
506: pay_payroll_actions ppa,
507: pay_assignment_actions paa,
508: pay_population_ranges ppr
509: where asgset.assignment_set_id = cp_asg_set
510: and asgset.include_or_exclude = 'I'
511: and paf.assignment_id = asgset.assignment_id

Line 542: pay_assignment_actions paa

538: AND hoi.org_information_context = 'Canada Employer Identification'
539: AND hoi.org_information5 = 'T4/RL1'
540: AND exists ( SELECT 1
541: FROM pay_payroll_actions ppa ,
542: pay_assignment_actions paa
543: WHERE ppa.report_type = 'CAEOY_T4_AMEND_PP'
544: AND ppa.report_qualifier = 'CAEOY_T4_AMEND_PPQ'
545: AND ppa.business_group_id = cp_bg_id
546: AND ppa.effective_date = cp_eff_date

Line 557: pay_assignment_actions paa_arch

553: cp_start_person number,
554: cp_end_person number) is
555: select distinct paa_arch.serial_number
556: from pay_payroll_actions ppa_arch,
557: pay_assignment_actions paa_arch
558: where ppa_arch.business_group_id = cp_bg_id
559: and ppa_arch.report_type = 'CAEOY_T4_AMEND_PP'
560: AND ppa_arch.report_qualifier = 'CAEOY_T4_AMEND_PPQ'
561: and ppa_arch.effective_date = cp_eff_date

Line 578: pay_assignment_actions paa_arch,

574: cp_start_person number,
575: cp_end_person number) is
576: select distinct paa_arch.serial_number
577: from pay_payroll_actions ppa_arch,
578: pay_assignment_actions paa_arch,
579: pay_population_ranges ppr
580: where ppa_arch.business_group_id = cp_bg_id
581: and ppa_arch.report_type = 'CAEOY_T4_AMEND_PP'
582: AND ppa_arch.report_qualifier = 'CAEOY_T4_AMEND_PPQ'

Line 607: pay_assignment_actions paa

603: paa.assignment_id,
604: paa.assignment_action_id,
605: paa.tax_unit_id
606: from pay_payroll_actions ppa,
607: pay_assignment_actions paa
608: where paa.serial_number = to_char(cp_person_id)
609: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)
610: and ppa.business_group_id = ln_business_group_id
611: and paa.action_status = 'C'

Line 617: pay_assignment_actions paa1,

613: and ppa.effective_date = cp_effective_date
614: and ppa.report_type = 'CAEOY_T4_AMEND_PP'
615: and not exists (select 1
616: from pay_action_interlocks pai,
617: pay_assignment_actions paa1,
618: pay_payroll_actions ppa1
619: where pai.locked_action_id = paa.assignment_action_id
620: and pai.locking_action_id = paa1.assignment_action_id
621: and paa1.payroll_action_id = ppa1.payroll_action_id

Line 640: pay_assignment_actions paa,

636: paa.assignment_action_id,
637: paa.tax_unit_id,
638: paf.effective_end_date
639: from pay_payroll_actions ppa,
640: pay_assignment_actions paa,
641: per_assignments_f paf
642: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
643: and paa.assignment_id = paf.assignment_id
644: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)

Line 654: pay_assignment_actions passt

650: and not exists
651: ( SELECT pail.locked_action_id
652: FROM pay_action_interlocks pail,
653: pay_payroll_actions pact,
654: pay_assignment_actions passt
655: WHERE pact.report_type in ('PAYCAT4AMPDF','CAEOY_T4_AMEND_PP')
656: AND pact.payroll_action_id = passt.payroll_action_id
657: AND pact.effective_date = cp_effective_date /*Added for 10381064*/
658: AND passt.assignment_action_id = pail.locking_action_id

Line 679: pay_assignment_actions paa

675: paa.assignment_id,
676: paa.assignment_action_id,
677: paa.tax_unit_id
678: from pay_payroll_actions ppa,
679: pay_assignment_actions paa
680: where paa.serial_number = to_char(cp_person_id)
681: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)
682: and ppa.business_group_id = ln_business_group_id
683: and paa.action_status = 'C'

Line 704: pay_assignment_actions paa,

700: paa.assignment_action_id,
701: paa.tax_unit_id,
702: paf.effective_end_date
703: from pay_payroll_actions ppa,
704: pay_assignment_actions paa,
705: per_assignments_f paf
706: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
707: and paa.assignment_id = paf.assignment_id
708: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)

Line 718: pay_assignment_actions passt

714: and exists
715: ( SELECT pail.locked_action_id
716: FROM pay_action_interlocks pail,
717: pay_payroll_actions pact,
718: pay_assignment_actions passt
719: WHERE pact.report_type = 'PAYCAT4AMPDF'
720: AND pact.payroll_action_id = passt.payroll_action_id
721: AND pact.effective_date = cp_effective_date /*Added for 10381064*/
722: AND passt.assignment_action_id = pail.locking_action_id

Line 730: pay_assignment_actions paa2

726: OR paa.assignment_action_id < passt.assignment_action_id))
727: and not exists
728: ( SELECT 1
729: FROM pay_payroll_actions ppa2,
730: pay_assignment_actions paa2
731: WHERE ppa2.report_type = 'CAEOY_T4_AMEND_PP'
732: AND ppa2.payroll_action_id = paa2.payroll_action_id
733: AND paa2.assignment_action_id > paa.assignment_action_id
734: AND paa2.tax_unit_id = paa.tax_unit_id

Line 757: pay_assignment_actions paa,

753: paa.assignment_action_id,
754: paa.tax_unit_id,
755: paf.effective_end_date
756: from pay_payroll_actions ppa,
757: pay_assignment_actions paa,
758: per_assignments_f paf,
759: per_periods_of_service PDS
760: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
761: and paa.assignment_id = paf.assignment_id

Line 772: pay_assignment_actions passt

768: and not exists
769: ( SELECT pail.locked_action_id
770: FROM pay_action_interlocks pail,
771: pay_payroll_actions pact,
772: pay_assignment_actions passt
773: WHERE pact.report_type in ('PAYCAT4AMPDF','CAEOY_T4_AMEND_PP')
774: AND pact.payroll_action_id = passt.payroll_action_id
775: AND pact.effective_date = cp_effective_date /*Added for 10381064*/
776: AND passt.assignment_action_id = pail.locking_action_id

Line 801: pay_assignment_actions paa,

797: paa.assignment_action_id,
798: paa.tax_unit_id,
799: paf.effective_end_date
800: from pay_payroll_actions ppa,
801: pay_assignment_actions paa,
802: per_assignments_f paf,
803: per_periods_of_service PDS
804: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
805: and paa.assignment_id = paf.assignment_id

Line 816: pay_assignment_actions passt

812: and exists
813: ( SELECT pail.locked_action_id
814: FROM pay_action_interlocks pail,
815: pay_payroll_actions pact,
816: pay_assignment_actions passt
817: WHERE pact.report_type = 'PAYCAT4AMPDF'
818: AND pact.payroll_action_id = passt.payroll_action_id
819: AND pact.effective_date = cp_effective_date /*Added for 10381064*/
820: AND passt.assignment_action_id = pail.locking_action_id

Line 828: pay_assignment_actions paa2

824: OR paa.assignment_action_id < passt.assignment_action_id))
825: and not exists
826: ( SELECT 1
827: FROM pay_payroll_actions ppa2,
828: pay_assignment_actions paa2
829: WHERE ppa2.report_type = 'CAEOY_T4_AMEND_PP'
830: AND ppa2.payroll_action_id = paa2.payroll_action_id
831: AND paa2.assignment_action_id > paa.assignment_action_id
832: AND paa2.tax_unit_id = paa.tax_unit_id

Line 1024: select pay_assignment_actions_s.nextval

1020: 'PRINT',
1021: 'ASSIGNMENT',
1022: ln_primary_assignment_id,
1023: l_effective_end_date),'Y') = 'Y' then
1024: select pay_assignment_actions_s.nextval
1025: into ln_t4amend_reg_asg_action
1026: from dual;
1027:
1028: hr_utility.trace('New T4 Amend Action = ' ||

Line 1031: /* Insert into pay_assignment_actions. */

1027:
1028: hr_utility.trace('New T4 Amend Action = ' ||
1029: to_char(ln_t4amend_reg_asg_action));
1030:
1031: /* Insert into pay_assignment_actions. */
1032: hr_nonrun_asact.insact(ln_t4amend_reg_asg_action
1033: ,ln_primary_assignment_id
1034: ,p_payroll_action_id
1035: ,p_chunk

Line 1053: update pay_assignment_actions aa

1049: ln_serial_number := lv_prov_of_emp||
1050: lpad(to_char(ln_asg_act_to_lock),14,0)||
1051: lpad(to_char(ln_yepp_pact_id),14,0);
1052:
1053: update pay_assignment_actions aa
1054: set aa.serial_number = ln_serial_number
1055: where aa.assignment_action_id = ln_t4amend_reg_asg_action;
1056: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1057: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));

Line 1212: select pay_assignment_actions_s.nextval

1208: 'PRINT',
1209: 'ASSIGNMENT',
1210: ln_primary_assignment_id,
1211: l_effective_end_date),'Y') = 'Y' then
1212: select pay_assignment_actions_s.nextval
1213: into ln_t4amend_reg_asg_action
1214: from dual;
1215:
1216: hr_utility.trace('New T4 Amend Action = ' ||

Line 1219: /* Insert into pay_assignment_actions. */

1215:
1216: hr_utility.trace('New T4 Amend Action = ' ||
1217: to_char(ln_t4amend_reg_asg_action));
1218:
1219: /* Insert into pay_assignment_actions. */
1220: hr_nonrun_asact.insact(ln_t4amend_reg_asg_action
1221: ,ln_primary_assignment_id
1222: ,p_payroll_action_id
1223: ,p_chunk

Line 1241: update pay_assignment_actions aa

1237: ln_serial_number := lv_prov_of_emp||
1238: lpad(to_char(ln_asg_act_to_lock),14,0)||
1239: lpad(to_char(ln_yepp_pact_id),14,0);
1240:
1241: update pay_assignment_actions aa
1242: set aa.serial_number = ln_serial_number
1243: where aa.assignment_action_id = ln_t4amend_reg_asg_action;
1244: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1245: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));

Line 1346: select pay_assignment_actions_s.nextval

1342: /* Create an assignment action for this person */
1343: hr_utility.trace('get_latest_t4amend_dtls found ');
1344: hr_utility.trace('Report Type: '||lv_report_type);
1345:
1346: select pay_assignment_actions_s.nextval
1347: into ln_t4amend_reg_asg_action
1348: from dual;
1349:
1350: hr_utility.trace('New T4 Amend Action = ' ||

Line 1353: /* Insert into pay_assignment_actions. */

1349:
1350: hr_utility.trace('New T4 Amend Action = ' ||
1351: to_char(ln_t4amend_reg_asg_action));
1352:
1353: /* Insert into pay_assignment_actions. */
1354: hr_nonrun_asact.insact(ln_t4amend_reg_asg_action
1355: ,ln_primary_assignment_id
1356: ,p_payroll_action_id
1357: ,p_chunk

Line 1375: update pay_assignment_actions aa

1371: ln_serial_number := lv_prov_of_emp||
1372: lpad(to_char(ln_asg_act_to_lock),14,0)||
1373: lpad(to_char(ln_yepp_pact_id),14,0);
1374:
1375: update pay_assignment_actions aa
1376: set aa.serial_number = ln_serial_number
1377: where aa.assignment_action_id = ln_t4amend_reg_asg_action;
1378: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1379: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));

Line 1455: select pay_assignment_actions_s.nextval

1451: hr_utility.trace('Report Type: '||lv_report_type);
1452:
1453: /* Create an assignment action for this person */
1454:
1455: select pay_assignment_actions_s.nextval
1456: into ln_t4amend_reg_asg_action
1457: from dual;
1458: hr_utility.trace('New T4 Amend Action = ' || ln_t4amend_reg_asg_action);
1459:

Line 1460: /* Insert into pay_assignment_actions. */

1456: into ln_t4amend_reg_asg_action
1457: from dual;
1458: hr_utility.trace('New T4 Amend Action = ' || ln_t4amend_reg_asg_action);
1459:
1460: /* Insert into pay_assignment_actions. */
1461: hr_nonrun_asact.insact(ln_t4amend_reg_asg_action
1462: ,ln_primary_assignment_id
1463: ,p_payroll_action_id
1464: ,p_chunk

Line 1485: update pay_assignment_actions aa

1481: hr_utility.trace('lv_prov_of_emp: '||substr(ln_serial_number,1,2));
1482: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
1483: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
1484:
1485: update pay_assignment_actions aa
1486: set aa.serial_number = ln_serial_number
1487: where aa.assignment_action_id = ln_t4amend_reg_asg_action;
1488:
1489: end if; -- lv_amend_flag = 'Y' condition

Line 1757: l_gre_id pay_assignment_actions.tax_unit_id%type;

1753: ) is
1754:
1755: l_dt date;
1756: l_year number ;
1757: l_gre_id pay_assignment_actions.tax_unit_id%type;
1758: l_per_id per_assignments_f.person_id%type;
1759: l_sort1 varchar2(60);
1760: l_sort2 varchar2(60);
1761: l_sort3 varchar2(60);

Line 1814: pay_assignment_actions paa1,

1810: hr_all_organization_units hou1,
1811: hr_locations_all loc,
1812: per_all_people_f ppf,
1813: per_all_assignments_f paf,
1814: pay_assignment_actions paa1,
1815: pay_payroll_actions ppa1
1816: where ppa1.payroll_action_id = :p_payroll_action_id
1817: and paa1.payroll_action_id = ppa1.payroll_action_id
1818: and paa1.assignment_id = paf.assignment_id