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

Line 64: Check on pay_payroll_actions table used in exists

60: and get_latest_t4a_amendpdf_dtls in pkg proc
61: pay_ca_eoy_t4a_amend_reg.action_creation
62: 08-DEC-2010 emunisek 115.16 10381064 Modified cursors get_latest_t4a_amendpdf_dtls,
63: get_reprint_t4a_amendpdf_dtls to introduce the Date
64: Check on pay_payroll_actions table used in exists
65: clauses
66: 29-Aug-2011 sneelapa 115.17 10399514 Introduced new CURSOR
67: c_selected_asg_set_range it will
68: be called in place of

Line 112: from pay_payroll_actions ppa

108: effective_date,
109: start_date,
110: business_group_id,
111: report_type
112: from pay_payroll_actions ppa
113: where ppa.payroll_action_id = cp_payroll_action_id;
114:
115: ld_end_date DATE;
116: ld_start_date DATE;

Line 204: from pay_payroll_actions ppa

200: report_qualifier,
201: report_category,
202: pay_ca_eoy_t4a_amend_reg.get_parameter(
203: 'PRINT_TERM',ppa.legislative_parameters)
204: from pay_payroll_actions ppa
205: where ppa.payroll_action_id = cp_payroll_action_id;
206:
207: ld_end_date DATE;
208: ld_start_date DATE;

Line 216: lv_report_qualifier pay_payroll_actions.report_qualifier%type;

212: ln_asg_set NUMBER := 0;
213: lv_print varchar2(10);
214: lv_report_type varchar2(50);
215: -- Variables declared for bug 10399514
216: lv_report_qualifier pay_payroll_actions.report_qualifier%type;
217: lv_report_cat pay_payroll_actions.report_category%type;
218: -- Variables declared for bug 10399514
219: l_print_term varchar2(1) := 'N';
220:

Line 217: lv_report_cat pay_payroll_actions.report_category%type;

213: lv_print varchar2(10);
214: lv_report_type varchar2(50);
215: -- Variables declared for bug 10399514
216: lv_report_qualifier pay_payroll_actions.report_qualifier%type;
217: lv_report_cat pay_payroll_actions.report_category%type;
218: -- Variables declared for bug 10399514
219: l_print_term varchar2(1) := 'N';
220:
221: BEGIN

Line 341: from pay_payroll_actions ppa_arch,

337: elsif ln_tax_unit_id is not NULL then
338:
339: lv_sql_string :=
340: 'select distinct paf.person_id
341: from pay_payroll_actions ppa_arch,
342: pay_assignment_actions paa_arch,
343: per_assignments_f paf,
344: pay_payroll_actions ppa
345: where paa_arch.assignment_id = paf.assignment_id

Line 344: pay_payroll_actions ppa

340: 'select distinct paf.person_id
341: from pay_payroll_actions ppa_arch,
342: pay_assignment_actions paa_arch,
343: per_assignments_f paf,
344: pay_payroll_actions ppa
345: where paa_arch.assignment_id = paf.assignment_id
346: and ppa.payroll_action_id = :p_payroll_action_id
347: and ppa_arch.business_group_id = ppa.business_group_id
348: and ppa_arch.effective_date = ppa.effective_date

Line 359: from pay_payroll_actions ppa_arch,

355: else
356:
357: lv_sql_string :=
358: 'select distinct paf.person_id
359: from pay_payroll_actions ppa_arch,
360: pay_assignment_actions paa_arch,
361: per_assignments_f paf,
362: pay_payroll_actions ppa
363: where paa_arch.assignment_id = paf.assignment_id

Line 362: pay_payroll_actions ppa

358: 'select distinct paf.person_id
359: from pay_payroll_actions ppa_arch,
360: pay_assignment_actions paa_arch,
361: per_assignments_f paf,
362: pay_payroll_actions ppa
363: where paa_arch.assignment_id = paf.assignment_id
364: and ppa.payroll_action_id = :p_payroll_action_id
365: and ppa_arch.business_group_id = ppa.business_group_id
366: and ppa_arch.effective_date = ppa.effective_date

Line 416: lv_report_type pay_payroll_actions.report_type%TYPE ;

412: ln_set_person_id NUMBER := 0 ;
413: ln_asg_set NUMBER := 0 ;
414: lv_print varchar2(10);
415:
416: lv_report_type pay_payroll_actions.report_type%TYPE ;
417:
418: -- Variables declared for bug 10399514
419: l_person_on boolean ;
420: l_report_cat pay_payroll_actions.report_category%type;

Line 420: l_report_cat pay_payroll_actions.report_category%type;

416: lv_report_type pay_payroll_actions.report_type%TYPE ;
417:
418: -- Variables declared for bug 10399514
419: l_person_on boolean ;
420: l_report_cat pay_payroll_actions.report_category%type;
421: l_state pay_payroll_actions.report_qualifier%type;
422: l_report_format pay_report_format_mappings_f.report_format%type;
423: -- Variables declared for bug 10399514
424:

Line 421: l_state pay_payroll_actions.report_qualifier%type;

417:
418: -- Variables declared for bug 10399514
419: l_person_on boolean ;
420: l_report_cat pay_payroll_actions.report_category%type;
421: l_state pay_payroll_actions.report_qualifier%type;
422: l_report_format pay_report_format_mappings_f.report_format%type;
423: -- Variables declared for bug 10399514
424:
425: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;

Line 444: pay_payroll_actions ppa,

440: ,cp_effective_date in date) is
441: select distinct paf.person_id
442: from hr_assignment_set_amendments asgset,
443: per_assignments_f paf,
444: pay_payroll_actions ppa,
445: pay_assignment_actions paa
446: where asgset.assignment_set_id = cp_asg_set
447: and asgset.include_or_exclude = 'I'
448: and paf.assignment_id = asgset.assignment_id

Line 469: pay_payroll_actions ppa,

465: ,cp_effective_date in date) is
466: select distinct paf.person_id
467: from hr_assignment_set_amendments asgset,
468: per_assignments_f paf,
469: pay_payroll_actions ppa,
470: pay_assignment_actions paa,
471: pay_population_ranges ppr
472: where asgset.assignment_set_id = cp_asg_set
473: and asgset.include_or_exclude = 'I'

Line 504: FROM pay_payroll_actions ppa ,

500: >= cp_eff_date
501: AND hoi.org_information_context = 'Canada Employer Identification'
502: AND hoi.org_information5 in ('T4A/RL1','T4A/RL2')
503: AND exists ( SELECT 1
504: FROM pay_payroll_actions ppa ,
505: pay_assignment_actions paa
506: WHERE ppa.report_type = 'CAEOY_T4A_AMEND_PP'
507: AND ppa.report_qualifier = 'CAEOY_T4A_AMEND_PPQ'
508: AND ppa.business_group_id = cp_bg_id

Line 519: from pay_payroll_actions ppa_arch,

515: cp_eff_date date,
516: cp_start_person number,
517: cp_end_person number) is
518: select distinct paa_arch.serial_number
519: from pay_payroll_actions ppa_arch,
520: pay_assignment_actions paa_arch
521: where ppa_arch.business_group_id = cp_bg_id
522: and ppa_arch.report_type = 'CAEOY_T4A_AMEND_PP'
523: AND ppa_arch.report_qualifier = 'CAEOY_T4A_AMEND_PPQ'

Line 540: from pay_payroll_actions ppa_arch,

536: cp_eff_date date,
537: cp_start_person number,
538: cp_end_person number) is
539: select distinct paa_arch.serial_number
540: from pay_payroll_actions ppa_arch,
541: pay_assignment_actions paa_arch,
542: pay_population_ranges ppr
543: where ppa_arch.business_group_id = cp_bg_id
544: and ppa_arch.report_type = 'CAEOY_T4A_AMEND_PP'

Line 569: from pay_payroll_actions ppa,

565: select ppa.report_type,
566: paa.assignment_id,
567: paa.assignment_action_id,
568: paa.tax_unit_id
569: from pay_payroll_actions ppa,
570: pay_assignment_actions paa
571: where paa.serial_number = to_char(cp_person_id)
572: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)
573: and ppa.business_group_id = ln_business_group_id

Line 581: pay_payroll_actions ppa1

577: and ppa.report_type = 'CAEOY_T4A_AMEND_PP'
578: and not exists (select 1
579: from pay_action_interlocks pai,
580: pay_assignment_actions paa1,
581: pay_payroll_actions ppa1
582: where pai.locked_action_id = paa.assignment_action_id
583: and pai.locking_action_id = paa1.assignment_action_id
584: and paa1.payroll_action_id = ppa1.payroll_action_id
585: and ppa1.report_type = ppa.report_type)

Line 601: from pay_payroll_actions ppa,

597: paa.assignment_id,
598: paa.assignment_action_id,
599: paa.tax_unit_id,
600: paf.effective_end_date
601: from pay_payroll_actions ppa,
602: pay_assignment_actions paa,
603: per_assignments_f paf
604: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
605: and paa.assignment_id = paf.assignment_id

Line 615: pay_payroll_actions pact,

611: and ppa.report_type = 'CAEOY_T4A_AMEND_PP'
612: and not exists
613: ( SELECT pail.locked_action_id
614: FROM pay_action_interlocks pail,
615: pay_payroll_actions pact,
616: pay_assignment_actions passt
617: WHERE pact.report_type IN ('PAYCAT4AAMPDF','CAEOY_T4A_AMEND_PP') -- #10352779
618: AND pact.payroll_action_id = passt.payroll_action_id
619: AND pact.effective_date = cp_effective_date /*Added for 10381064*/

Line 640: from pay_payroll_actions ppa,

636: select ppa.report_type,
637: paa.assignment_id,
638: paa.assignment_action_id,
639: paa.tax_unit_id
640: from pay_payroll_actions ppa,
641: pay_assignment_actions paa
642: where paa.serial_number = to_char(cp_person_id)
643: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)
644: and ppa.business_group_id = ln_business_group_id

Line 664: from pay_payroll_actions ppa,

660: paa.assignment_id,
661: paa.assignment_action_id,
662: paa.tax_unit_id,
663: paf.effective_end_date
664: from pay_payroll_actions ppa,
665: pay_assignment_actions paa,
666: per_assignments_f paf
667: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
668: and paa.assignment_id = paf.assignment_id

Line 678: pay_payroll_actions pact,

674: and ppa.report_type = 'CAEOY_T4A_AMEND_PP'
675: and exists
676: ( SELECT pail.locked_action_id
677: FROM pay_action_interlocks pail,
678: pay_payroll_actions pact,
679: pay_assignment_actions passt
680: WHERE pact.report_type = 'PAYCAT4AAMPDF'
681: AND pact.payroll_action_id = passt.payroll_action_id
682: AND pact.effective_date = cp_effective_date /*Added for 10381064*/

Line 695: from pay_payroll_actions ppa2,

691: and paf.effective_start_date <= cp_effective_date
692: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
693: /* Added not exists condition for # 10323048 */
694: and not exists (select 1
695: from pay_payroll_actions ppa2,
696: pay_assignment_actions paa2
697: where ppa2.payroll_action_id = paa2.payroll_action_id
698: and ppa2.report_type = 'CAEOY_T4A_AMEND_PP'
699: and paa2.assignment_id = paa.assignment_id

Line 716: from pay_payroll_actions ppa,

712: paa.assignment_id,
713: paa.assignment_action_id,
714: paa.tax_unit_id,
715: paf.effective_end_date
716: from pay_payroll_actions ppa,
717: pay_assignment_actions paa,
718: per_assignments_f paf,
719: per_periods_of_service pds
720: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)

Line 731: pay_payroll_actions pact,

727: and ppa.report_type = 'CAEOY_T4A_AMEND_PP'
728: and not exists
729: ( SELECT pail.locked_action_id
730: FROM pay_action_interlocks pail,
731: pay_payroll_actions pact,
732: pay_assignment_actions passt
733: WHERE pact.report_type IN ('PAYCAT4AAMPDF','CAEOY_T4A_AMEND_PP') -- #10352779
734: AND pact.payroll_action_id = passt.payroll_action_id
735: AND pact.effective_date = cp_effective_date /*Added for 10381064*/

Line 759: from pay_payroll_actions ppa,

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

Line 774: pay_payroll_actions pact,

770: and ppa.report_type = 'CAEOY_T4A_AMEND_PP'
771: and exists
772: ( SELECT pail.locked_action_id
773: FROM pay_action_interlocks pail,
774: pay_payroll_actions pact,
775: pay_assignment_actions passt
776: WHERE pact.report_type = 'PAYCAT4AAMPDF'
777: AND pact.payroll_action_id = passt.payroll_action_id
778: AND pact.effective_date = cp_effective_date /*Added for 10381064*/

Line 791: from pay_payroll_actions ppa2,

787: and paf.effective_start_date <= cp_effective_date
788: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
789: /* Added not exists condition for # 10323048 */
790: and not exists (select 1
791: from pay_payroll_actions ppa2,
792: pay_assignment_actions paa2
793: where ppa2.payroll_action_id = paa2.payroll_action_id
794: and ppa2.report_type = 'CAEOY_T4A_AMEND_PP'
795: and paa2.assignment_id = paa.assignment_id

Line 811: from pay_payroll_actions

807: CURSOR get_yepp_pact_id(cp_bg_id number,
808: cp_gre number,
809: cp_year date) IS
810: select payroll_action_id
811: from pay_payroll_actions
812: where business_group_id = cp_bg_id
813: and report_type = 'T4A'
814: and report_qualifier = 'CAEOY'
815: and action_type = 'X'

Line 1648: pay_payroll_actions ppa1

1644: hr_locations_all loc,
1645: per_all_people_f ppf,
1646: per_all_assignments_f paf,
1647: pay_assignment_actions paa1,
1648: pay_payroll_actions ppa1
1649: where ppa1.payroll_action_id = :p_payroll_action_id
1650: and paa1.payroll_action_id = ppa1.payroll_action_id
1651: and paa1.assignment_id = paf.assignment_id
1652: and paf.effective_start_date =

Line 1697: token_val pay_payroll_actions.legislative_parameters%type;

1693: parameter_list varchar2) return varchar2
1694: IS
1695: start_ptr number;
1696: end_ptr number;
1697: token_val pay_payroll_actions.legislative_parameters%type;
1698: par_value pay_payroll_actions.legislative_parameters%type;
1699:
1700: BEGIN
1701:

Line 1698: par_value pay_payroll_actions.legislative_parameters%type;

1694: IS
1695: start_ptr number;
1696: end_ptr number;
1697: token_val pay_payroll_actions.legislative_parameters%type;
1698: par_value pay_payroll_actions.legislative_parameters%type;
1699:
1700: BEGIN
1701:
1702: token_val := name||'=';