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

Line 266: ln_agent_tax_unit_id pay_assignment_actions.tax_unit_id%type;

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

Line 318: pay_assignment_actions paa_rep,

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

Line 336: pay_assignment_actions paa_rep,

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

Line 402: ln_rep_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;

398: l_state pay_payroll_actions.report_qualifier%type;
399: l_report_format pay_report_format_mappings_f.report_format%type;
400: -- Variables declared for bug 10399514
401:
402: ln_rep_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
403: ln_arch_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
404: ln_second_last_arch_action pay_assignment_actions.assignment_action_id%TYPE;
405: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;
406:

Line 403: ln_arch_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;

399: l_report_format pay_report_format_mappings_f.report_format%type;
400: -- Variables declared for bug 10399514
401:
402: ln_rep_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
403: ln_arch_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
404: ln_second_last_arch_action pay_assignment_actions.assignment_action_id%TYPE;
405: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;
406:
407:

Line 404: ln_second_last_arch_action pay_assignment_actions.assignment_action_id%TYPE;

400: -- Variables declared for bug 10399514
401:
402: ln_rep_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
403: ln_arch_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
404: ln_second_last_arch_action pay_assignment_actions.assignment_action_id%TYPE;
405: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;
406:
407:
408: lv_serial_number VARCHAR2(30);

Line 405: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;

401:
402: ln_rep_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
403: ln_arch_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
404: ln_second_last_arch_action pay_assignment_actions.assignment_action_id%TYPE;
405: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;
406:
407:
408: lv_serial_number VARCHAR2(30);
409: lv_employee_number per_people_f.employee_number%type;

Line 414: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;

410: lv_message varchar2(240):= null;
411: lv_full_name per_people_f.full_name%type;
412: lv_record_name varchar2(100);
413: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
414: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
415: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;
416: ln_serial_number pay_assignment_actions.serial_number%TYPE;
417: ln_gre_id NUMBER;
418: ln_gre_parameter NUMBER;

Line 415: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;

411: lv_full_name per_people_f.full_name%type;
412: lv_record_name varchar2(100);
413: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
414: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
415: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;
416: ln_serial_number pay_assignment_actions.serial_number%TYPE;
417: ln_gre_id NUMBER;
418: ln_gre_parameter NUMBER;
419: lv_ppr_report_type varchar2(50);

Line 416: ln_serial_number pay_assignment_actions.serial_number%TYPE;

412: lv_record_name varchar2(100);
413: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
414: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
415: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;
416: ln_serial_number pay_assignment_actions.serial_number%TYPE;
417: ln_gre_id NUMBER;
418: ln_gre_parameter NUMBER;
419: lv_ppr_report_type varchar2(50);
420:

Line 431: pay_assignment_actions paa

427: select distinct paf.person_id
428: from hr_assignment_set_amendments asgset,
429: per_assignments_f paf,
430: pay_payroll_actions ppa,
431: pay_assignment_actions paa
432: where asgset.assignment_set_id = cp_asg_set
433: and asgset.include_or_exclude = 'I'
434: and paf.assignment_id = asgset.assignment_id
435: and paf.person_id between cp_start_person

Line 454: pay_assignment_actions paa,

450: select distinct paf.person_id
451: from hr_assignment_set_amendments asgset,
452: per_assignments_f paf,
453: pay_payroll_actions ppa,
454: pay_assignment_actions paa,
455: pay_population_ranges ppr
456: where asgset.assignment_set_id = cp_asg_set
457: and asgset.include_or_exclude = 'I'
458: and paf.assignment_id = asgset.assignment_id

Line 488: pay_assignment_actions paa

484: AND hoi.org_information_context = 'Canada Employer Identification'
485: AND hoi.org_information5 like 'T4A%'
486: AND exists ( SELECT 1
487: FROM pay_payroll_actions ppa ,
488: pay_assignment_actions paa
489: WHERE ppa.report_type in ('PAYCAT4APDF','PAYCAT4AAMPDF')
490: AND ppa.report_qualifier = 'DEFAULT'
491: AND ppa.business_group_id = cp_bg_id
492: AND ppa.effective_date = cp_eff_date

Line 503: pay_assignment_actions paa_rep,

499: cp_start_person number,
500: cp_end_person number) is
501: select distinct paf.person_id
502: from pay_payroll_actions ppa_rep,
503: pay_assignment_actions paa_rep,
504: per_assignments_f paf
505: where ppa_rep.business_group_id = cp_bg_id
506: and ppa_rep.report_type in ('PAYCAT4APDF','PAYCAT4AAMPDF')
507: and ppa_rep.report_qualifier = 'DEFAULT'

Line 526: pay_assignment_actions paa_rep,

522: cp_start_person number,
523: cp_end_person number) is
524: select distinct paf.person_id
525: from pay_payroll_actions ppa_rep,
526: pay_assignment_actions paa_rep,
527: per_assignments_f paf,
528: pay_population_ranges ppr
529: where ppa_rep.business_group_id = cp_bg_id
530: and ppa_rep.report_type in ('PAYCAT4APDF','PAYCAT4AAMPDF')

Line 558: pay_assignment_actions paa,

554: paa.tax_unit_id,
555: paa.serial_number,
556: paf.effective_end_date
557: from pay_payroll_actions ppa,
558: pay_assignment_actions paa,
559: per_assignments_f paf
560: where paf.person_id = to_char(cp_person_id)
561: and paf.assignment_id = paa.assignment_id
562: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)

Line 578: pay_assignment_actions paa1,

574: and paf.effective_start_date <= cp_effective_date
575: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
576: and not exists (select 1
577: from pay_action_interlocks pai,
578: pay_assignment_actions paa1,
579: pay_payroll_actions ppa1
580: where pai.locked_action_id = paa.assignment_action_id
581: and pai.locking_action_id = paa1.assignment_action_id
582: and ppa1.effective_date = ppa.effective_date

Line 587: from pay_assignment_actions paa2,

583: and paa1.tax_unit_id = paa.tax_unit_id
584: and paa1.payroll_action_id = ppa1.payroll_action_id
585: and ppa1.report_type = 'PAYCAT4ACLPDF')
586: and not exists (select 1
587: from pay_assignment_actions paa2,
588: pay_payroll_actions ppa2
589: where paa2.payroll_action_id = ppa2.payroll_action_id
590: and ppa2.report_type in ('PAYCAT4APDF','PAYCAT4AAMPDF')
591: and ppa2.effective_date = ppa.effective_date

Line 612: pay_assignment_actions paa,

608: paa.tax_unit_id,
609: paa.serial_number,
610: paf.effective_end_date
611: from pay_payroll_actions ppa,
612: pay_assignment_actions paa,
613: per_assignments_f paf
614: where paf.person_id = to_char(cp_person_id)
615: and paf.assignment_id = paa.assignment_id
616: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)

Line 631: pay_assignment_actions paa1

627: and exists
628: ( SELECT pail.locked_action_id
629: FROM pay_action_interlocks pail,
630: pay_payroll_actions ppa1,
631: pay_assignment_actions paa1
632: WHERE ppa1.report_type = 'PAYCAT4ACLPDF'
633: AND ppa1.payroll_action_id = paa1.payroll_action_id
634: AND ppa1.effective_date = cp_effective_date
635: AND paa1.assignment_action_id = pail.locking_action_id

Line 640: from pay_assignment_actions paa2,

636: AND paa1.tax_unit_id = paa.tax_unit_id
637: AND paa1.assignment_id=paf.assignment_id
638: AND pail.locked_action_id = paa.assignment_action_id)
639: AND not exists (select 1
640: from pay_assignment_actions paa2,
641: pay_payroll_actions ppa2
642: where paa2.payroll_action_id = ppa2.payroll_action_id
643: and ppa2.report_type in ('PAYCAT4APDF','PAYCAT4AAMPDF')
644: and ppa2.effective_date = ppa.effective_date

Line 666: pay_assignment_actions paa,

662: paa.tax_unit_id,
663: paa.serial_number,
664: paf.effective_end_date
665: from pay_payroll_actions ppa,
666: pay_assignment_actions paa,
667: per_assignments_f paf,
668: per_periods_of_service pds
669: where paf.person_id = to_char(cp_person_id)
670: and paf.assignment_id = paa.assignment_id

Line 687: pay_assignment_actions paa1,

683: and paf.effective_start_date <= cp_effective_date
684: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
685: and not exists (select 1
686: from pay_action_interlocks pai,
687: pay_assignment_actions paa1,
688: pay_payroll_actions ppa1
689: where pai.locked_action_id = paa.assignment_action_id
690: and pai.locking_action_id = paa1.assignment_action_id
691: and ppa1.effective_date = ppa.effective_date

Line 696: from pay_assignment_actions paa2,

692: and paa1.tax_unit_id = paa.tax_unit_id
693: and paa1.payroll_action_id = ppa1.payroll_action_id
694: and ppa1.report_type = 'PAYCAT4ACLPDF')
695: and not exists (select 1
696: from pay_assignment_actions paa2,
697: pay_payroll_actions ppa2
698: where paa2.payroll_action_id = ppa2.payroll_action_id
699: and ppa2.report_type in ('PAYCAT4APDF','PAYCAT4AAMPDF')
700: and ppa2.effective_date = ppa.effective_date

Line 723: pay_assignment_actions paa,

719: paa.tax_unit_id,
720: paa.serial_number,
721: paf.effective_end_date
722: from pay_payroll_actions ppa,
723: pay_assignment_actions paa,
724: per_assignments_f paf,
725: per_periods_of_service pds
726: where paf.person_id = to_char(cp_person_id)
727: and paf.assignment_id = paa.assignment_id

Line 743: pay_assignment_actions paa1

739: and exists
740: ( SELECT pail.locked_action_id
741: FROM pay_action_interlocks pail,
742: pay_payroll_actions ppa1,
743: pay_assignment_actions paa1
744: WHERE ppa1.report_type = 'PAYCAT4ACLPDF'
745: AND ppa1.payroll_action_id = paa1.payroll_action_id
746: AND ppa1.effective_date = cp_effective_date
747: AND paa1.assignment_action_id = pail.locking_action_id

Line 752: from pay_assignment_actions paa2,

748: AND paa1.tax_unit_id = paa.tax_unit_id
749: AND paa1.assignment_id=paf.assignment_id
750: AND pail.locked_action_id = paa.assignment_action_id)
751: AND not exists (select 1
752: from pay_assignment_actions paa2,
753: pay_payroll_actions ppa2
754: where paa2.payroll_action_id = ppa2.payroll_action_id
755: and ppa2.report_type in ('PAYCAT4APDF','PAYCAT4AAMPDF')
756: and ppa2.effective_date = ppa.effective_date

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

772: from per_people_f
773: where person_id = cp_person_id
774: order by effective_end_date desc;
775:
776: CURSOR check_arch_action_exists (p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) is
777: select 'Y'
778: from pay_assignment_actions
779: where assignment_action_id = p_assignment_action_id;
780:

Line 778: from pay_assignment_actions

774: order by effective_end_date desc;
775:
776: CURSOR check_arch_action_exists (p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) is
777: select 'Y'
778: from pay_assignment_actions
779: where assignment_action_id = p_assignment_action_id;
780:
781: lv_gross_earn_value varchar2(30);
782: lv_jurisdiction varchar2(10);

Line 788: lv_serial_number pay_assignment_actions.serial_number%TYPE;

784: ln_gross_earn_ue_id number;
785: ln_yepp_pact_id number;
786: ln_gre_id_null number;
787: lv_flag_count number :=0;
788: lv_serial_number pay_assignment_actions.serial_number%TYPE;
789:
790: lv_negative_bal_flag varchar2(10);
791: lv_neg_bal_mesg varchar2(100);
792: lv_person_type varchar2(20);

Line 937: select pay_assignment_actions_s.nextval

933: 'PRINT',
934: 'ASSIGNMENT',
935: ln_primary_assignment_id,
936: l_effective_end_date),'Y') = 'Y' then
937: select pay_assignment_actions_s.nextval
938: into ln_t4acancel_asg_action
939: from dual;
940:
941: hr_utility.trace('New T4A Cancel Action = ' ||

Line 944: /* Insert into pay_assignment_actions. */

940:
941: hr_utility.trace('New T4A Cancel Action = ' ||
942: to_char(ln_t4acancel_asg_action));
943:
944: /* Insert into pay_assignment_actions. */
945: hr_nonrun_asact.insact(ln_t4acancel_asg_action
946: ,ln_primary_assignment_id
947: ,p_payroll_action_id
948: ,p_chunk

Line 965: update pay_assignment_actions aa

961: ln_serial_number := lpad(to_char(ln_arch_act_to_lock),14,0)||
962: lpad(to_char(ln_rep_act_to_lock),14,0)||
963: lv_negative_bal_flag;
964:
965: update pay_assignment_actions aa
966: set aa.serial_number = ln_serial_number
967: where aa.assignment_action_id = ln_t4acancel_asg_action;
968:
969: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,1,14));

Line 1129: select pay_assignment_actions_s.nextval

1125: 'ASSIGNMENT',
1126: ln_primary_assignment_id,
1127: l_effective_end_date),'Y') = 'Y' then
1128:
1129: select pay_assignment_actions_s.nextval
1130: into ln_t4acancel_asg_action
1131: from dual;
1132:
1133: hr_utility.trace('New T4A Cancel Action = ' ||

Line 1136: /* Insert into pay_assignment_actions. */

1132:
1133: hr_utility.trace('New T4A Cancel Action = ' ||
1134: to_char(ln_t4acancel_asg_action));
1135:
1136: /* Insert into pay_assignment_actions. */
1137: hr_nonrun_asact.insact(ln_t4acancel_asg_action
1138: ,ln_primary_assignment_id
1139: ,p_payroll_action_id
1140: ,p_chunk

Line 1157: update pay_assignment_actions aa

1153: ln_serial_number := lpad(to_char(ln_arch_act_to_lock),14,0)||
1154: lpad(to_char(ln_rep_act_to_lock),14,0)||
1155: lv_negative_bal_flag;
1156:
1157: update pay_assignment_actions aa
1158: set aa.serial_number = ln_serial_number
1159: where aa.assignment_action_id = ln_t4acancel_asg_action;
1160:
1161: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,1,14));

Line 1429: l_gre_id pay_assignment_actions.tax_unit_id%type;

1425: ) is
1426:
1427: l_dt date;
1428: l_year number ;
1429: l_gre_id pay_assignment_actions.tax_unit_id%type;
1430: l_per_id per_assignments_f.person_id%type;
1431: l_sort1 varchar2(60);
1432: l_sort2 varchar2(60);
1433: l_sort3 varchar2(60);

Line 1486: pay_assignment_actions paa1,

1482: hr_all_organization_units hou1,
1483: hr_locations_all loc,
1484: per_all_people_f ppf,
1485: per_all_assignments_f paf,
1486: pay_assignment_actions paa1,
1487: pay_payroll_actions ppa1
1488: where ppa1.payroll_action_id = :p_payroll_action_id
1489: and paa1.payroll_action_id = ppa1.payroll_action_id
1490: and paa1.assignment_id = paf.assignment_id