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_PAYROLL_ACTIONS

Line 82: Check on pay_payroll_actions table used in exists

78: cursors are already taking care of the requirement and it
79: is preventing the expected outputs in some scenarios.
80: 08-DEC-2010 emunisek 115.18 10381064 Modified cursors get_latest_t4amendpdf_dtls,
81: get_reprint_t4amendpdf_dtls to introduce the Date
82: Check on pay_payroll_actions table used in exists
83: clauses
84: 07-SEP-2011 rgottipa 115.19 10399514 introduced new cursores
85: c_selected_asg_set_range and
86: c_all_asg_range. These will be

Line 136: from pay_payroll_actions ppa

132: business_group_id,
133: pay_ca_eoy_t4_amend_reg.get_parameter(
134: 'PROV_CD',ppa.legislative_parameters),
135: report_type
136: from pay_payroll_actions ppa
137: where ppa.payroll_action_id = cp_payroll_action_id;
138:
139: ld_end_date DATE;
140: ld_start_date DATE;

Line 225: from pay_payroll_actions ppa

221: report_qualifier,
222: report_category,
223: pay_ca_eoy_t4_amend_reg.get_parameter(
224: 'PRINT_TERM',ppa.legislative_parameters)
225: from pay_payroll_actions ppa
226: where ppa.payroll_action_id = cp_payroll_action_id;
227:
228: ld_end_date DATE;
229: ld_start_date DATE;

Line 238: lv_report_qualifier pay_payroll_actions.report_qualifier%type;

234: lv_print varchar2(10);
235: lv_prov_cd varchar2(5);
236: lv_report_type varchar2(50);
237: -- Variables declared for bug 10399514
238: lv_report_qualifier pay_payroll_actions.report_qualifier%type;
239: lv_report_cat pay_payroll_actions.report_category%type;
240: -- Variables declared for bug 10399514
241: l_print_term varchar2(1) := 'N';
242:

Line 239: lv_report_cat pay_payroll_actions.report_category%type;

235: lv_prov_cd varchar2(5);
236: lv_report_type varchar2(50);
237: -- Variables declared for bug 10399514
238: lv_report_qualifier pay_payroll_actions.report_qualifier%type;
239: lv_report_cat pay_payroll_actions.report_category%type;
240: -- Variables declared for bug 10399514
241: l_print_term varchar2(1) := 'N';
242:
243: BEGIN

Line 370: from pay_payroll_actions ppa_arch,

366: elsif ln_tax_unit_id is not NULL then
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

Line 373: pay_payroll_actions ppa

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
376: and ppa_arch.business_group_id = ppa.business_group_id
377: and ppa_arch.effective_date = ppa.effective_date

Line 388: from pay_payroll_actions ppa_arch,

384: else
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

Line 391: pay_payroll_actions ppa

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
394: and ppa_arch.business_group_id = ppa.business_group_id
395: and ppa_arch.effective_date = ppa.effective_date

Line 447: lv_report_type pay_payroll_actions.report_type%TYPE ;

443: ln_asg_set NUMBER := 0 ;
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:

Line 458: lv_prev_report_type pay_payroll_actions.report_type%TYPE;

454: lv_employee_number per_people_f.employee_number%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;

Line 468: l_report_cat pay_payroll_actions.report_category%type;

464: lv_ppr_report_type varchar2(50);
465:
466: -- Variables declared for bug 10399514
467: l_person_on boolean ;
468: l_report_cat pay_payroll_actions.report_category%type;
469: l_state pay_payroll_actions.report_qualifier%type;
470: l_report_format pay_report_format_mappings_f.report_format%type;
471: -- Variables declared for bug 10399514
472:

Line 469: l_state pay_payroll_actions.report_qualifier%type;

465:
466: -- Variables declared for bug 10399514
467: l_person_on boolean ;
468: l_report_cat pay_payroll_actions.report_category%type;
469: l_state pay_payroll_actions.report_qualifier%type;
470: l_report_format pay_report_format_mappings_f.report_format%type;
471: -- Variables declared for bug 10399514
472:
473: l_print_term varchar2(1);

Line 482: pay_payroll_actions ppa,

478: ,cp_effective_date in date) is
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

Line 506: pay_payroll_actions ppa,

502: ,cp_effective_date in date) is
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'

Line 541: FROM pay_payroll_actions ppa ,

537: >= cp_eff_date
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

Line 556: from pay_payroll_actions ppa_arch,

552: cp_eff_date date,
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'

Line 577: from pay_payroll_actions ppa_arch,

573: cp_eff_date date,
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'

Line 606: from pay_payroll_actions ppa,

602: select ppa.report_type,
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

Line 618: pay_payroll_actions ppa1

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
622: and ppa1.report_type = ppa.report_type)

Line 639: from pay_payroll_actions ppa,

635: paa.assignment_id,
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

Line 653: pay_payroll_actions pact,

649: and ppa.report_type = 'CAEOY_T4_AMEND_PP'
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*/

Line 678: from pay_payroll_actions ppa,

674: select ppa.report_type,
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

Line 703: from pay_payroll_actions ppa,

699: paa.assignment_id,
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

Line 717: pay_payroll_actions pact,

713: and ppa.report_type = 'CAEOY_T4_AMEND_PP'
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*/

Line 729: FROM pay_payroll_actions ppa2,

725: AND (pail.locked_action_id = paa.assignment_action_id
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

Line 756: from pay_payroll_actions ppa,

752: paa.assignment_id,
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)

Line 771: pay_payroll_actions pact,

767: and ppa.report_type = 'CAEOY_T4_AMEND_PP'
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*/

Line 800: from pay_payroll_actions ppa,

796: paa.assignment_id,
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)

Line 815: pay_payroll_actions pact,

811: and ppa.report_type = 'CAEOY_T4_AMEND_PP'
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*/

Line 827: FROM pay_payroll_actions ppa2,

823: AND (pail.locked_action_id = paa.assignment_action_id
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

Line 853: from pay_payroll_actions

849: CURSOR get_yepp_pact_id(cp_bg_id number,
850: cp_gre number,
851: cp_year date) IS
852: select payroll_action_id
853: from pay_payroll_actions
854: where business_group_id = cp_bg_id
855: and report_type = 'T4'
856: and report_qualifier = 'CAEOY'
857: and action_type = 'X'

Line 1766: l_bg_id pay_payroll_actions.business_group_id%type ;

1762: l_year_start date;
1763: l_year_end date;
1764: l_print varchar2(20);
1765: l_asg_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;
1766: l_bg_id pay_payroll_actions.business_group_id%type ;
1767:
1768: begin
1769:
1770: begin

Line 1793: from pay_payroll_actions ppa

1789: l_print,
1790: l_year_end,
1791: l_year_start,
1792: l_bg_id
1793: from pay_payroll_actions ppa
1794: where ppa.payroll_action_id = payactid;
1795:
1796: exception when no_data_found then
1797: hr_utility.trace('Error in Sort Procedure - getting legislative param');

Line 1815: pay_payroll_actions ppa1

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
1819: and paf.effective_start_date =

Line 1866: token_val pay_payroll_actions.legislative_parameters%type;

1862: parameter_list varchar2) return varchar2
1863: IS
1864: start_ptr number;
1865: end_ptr number;
1866: token_val pay_payroll_actions.legislative_parameters%type;
1867: par_value pay_payroll_actions.legislative_parameters%type;
1868:
1869: BEGIN
1870:

Line 1867: par_value pay_payroll_actions.legislative_parameters%type;

1863: IS
1864: start_ptr number;
1865: end_ptr number;
1866: token_val pay_payroll_actions.legislative_parameters%type;
1867: par_value pay_payroll_actions.legislative_parameters%type;
1868:
1869: BEGIN
1870:
1871: token_val := name||'=';