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_PAYROLL_ACTIONS

Line 82: from pay_payroll_actions ppa

78: business_group_id,
79: pay_ca_eoy_t4_cancel_pkg.get_parameter(
80: 'PROV_CD',ppa.legislative_parameters),
81: report_type
82: from pay_payroll_actions ppa
83: where ppa.payroll_action_id = cp_payroll_action_id;
84:
85: ld_end_date DATE;
86: ld_start_date DATE;

Line 172: from pay_payroll_actions ppa

168: report_qualifier,
169: report_category,
170: pay_ca_eoy_t4_cancel_pkg.get_parameter(
171: 'PRINT_TERM',ppa.legislative_parameters)
172: from pay_payroll_actions ppa
173: where ppa.payroll_action_id = cp_payroll_action_id;
174:
175: ld_end_date DATE;
176: ld_start_date DATE;

Line 185: lv_report_qualifier pay_payroll_actions.report_qualifier%type;

181: lv_print varchar2(10);
182: lv_prov_cd varchar2(5);
183: lv_report_type varchar2(50);
184: -- Variables declared for bug 10399514
185: lv_report_qualifier pay_payroll_actions.report_qualifier%type;
186: lv_report_cat pay_payroll_actions.report_category%type;
187: -- Variables declared for bug 10399514
188: l_print_term varchar2(1) := 'N';
189:

Line 186: lv_report_cat pay_payroll_actions.report_category%type;

182: lv_prov_cd varchar2(5);
183: lv_report_type varchar2(50);
184: -- Variables declared for bug 10399514
185: lv_report_qualifier pay_payroll_actions.report_qualifier%type;
186: lv_report_cat pay_payroll_actions.report_category%type;
187: -- Variables declared for bug 10399514
188: l_print_term varchar2(1) := 'N';
189:
190: BEGIN

Line 318: from pay_payroll_actions ppa_rep,

314: elsif ln_tax_unit_id is not NULL and lv_prov_cd is not NULL then
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

Line 321: pay_payroll_actions ppa

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
324: and ppa_rep.business_group_id = ppa.business_group_id
325: and ppa_rep.effective_date = ppa.effective_date

Line 337: from pay_payroll_actions ppa_rep,

333: elsif ln_tax_unit_id is not NULL and lv_prov_cd is NULL then
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

Line 340: pay_payroll_actions ppa

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
343: and ppa_rep.business_group_id = ppa.business_group_id
344: and ppa_rep.effective_date = ppa.effective_date

Line 355: from pay_payroll_actions ppa_rep,

351: elsif ln_tax_unit_id is NULL and lv_prov_cd is not NULL then
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

Line 358: pay_payroll_actions ppa

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
361: and ppa_rep.business_group_id = ppa.business_group_id
362: and ppa_rep.effective_date = ppa.effective_date

Line 373: from pay_payroll_actions ppa_rep,

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

Line 376: pay_payroll_actions ppa

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
379: and ppa_rep.business_group_id = ppa.business_group_id
380: and ppa_rep.effective_date = ppa.effective_date

Line 432: lv_report_type pay_payroll_actions.report_type%TYPE ;

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

Line 444: lv_prev_report_type pay_payroll_actions.report_type%TYPE;

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

Line 453: l_report_cat pay_payroll_actions.report_category%type;

449: ln_gre_parameter NUMBER;
450: lv_ppr_report_type varchar2(50);
451: -- Variables declared for bug 10399514
452: l_person_on boolean ;
453: l_report_cat pay_payroll_actions.report_category%type;
454: l_state pay_payroll_actions.report_qualifier%type;
455: l_report_format pay_report_format_mappings_f.report_format%type;
456: -- Variables declared for bug 10399514
457:

Line 454: l_state pay_payroll_actions.report_qualifier%type;

450: lv_ppr_report_type varchar2(50);
451: -- Variables declared for bug 10399514
452: l_person_on boolean ;
453: l_report_cat pay_payroll_actions.report_category%type;
454: l_state pay_payroll_actions.report_qualifier%type;
455: l_report_format pay_report_format_mappings_f.report_format%type;
456: -- Variables declared for bug 10399514
457:
458: l_print_term varchar2(1);

Line 467: pay_payroll_actions ppa,

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

Line 491: pay_payroll_actions ppa,

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

Line 524: FROM pay_payroll_actions ppa ,

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

Line 539: from pay_payroll_actions ppa_rep,

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

Line 563: from pay_payroll_actions ppa_rep,

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

Line 594: from pay_payroll_actions ppa,

590: paa.assignment_action_id,
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

Line 617: pay_payroll_actions ppa1

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
621: and paa1.tax_unit_id = paa.tax_unit_id

Line 626: pay_payroll_actions ppa2

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
630: and substr(paa2.serial_number,1,2) = substr(paa.serial_number,1,2)

Line 648: from pay_payroll_actions ppa,

644: paa.assignment_action_id,
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

Line 668: pay_payroll_actions ppa1,

664: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
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

Line 680: pay_payroll_actions ppa2

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
684: and substr(paa2.serial_number,1,2) = substr(paa.serial_number,1,2)

Line 704: from pay_payroll_actions ppa,

700: paa.assignment_action_id,
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)

Line 728: pay_payroll_actions ppa1

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
732: and paa1.tax_unit_id = paa.tax_unit_id

Line 737: pay_payroll_actions ppa2

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
741: and substr(paa2.serial_number,1,2) = substr(paa.serial_number,1,2)

Line 761: from pay_payroll_actions ppa,

757: paa.assignment_action_id,
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)

Line 782: pay_payroll_actions ppa1,

778: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
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

Line 794: pay_payroll_actions ppa2

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
798: and substr(paa2.serial_number,1,2) = substr(paa.serial_number,1,2)

Line 1414: l_bg_id pay_payroll_actions.business_group_id%type ;

1410: l_year_start date;
1411: l_year_end date;
1412: l_print varchar2(20);
1413: l_asg_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;
1414: l_bg_id pay_payroll_actions.business_group_id%type ;
1415:
1416: begin
1417:
1418: begin

Line 1441: from pay_payroll_actions ppa

1437: l_print,
1438: l_year_end,
1439: l_year_start,
1440: l_bg_id
1441: from pay_payroll_actions ppa
1442: where ppa.payroll_action_id = payactid;
1443:
1444: exception when no_data_found then
1445: hr_utility.trace('Error in Sort Procedure - getting legislative param');

Line 1463: pay_payroll_actions ppa1

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

Line 1514: token_val pay_payroll_actions.legislative_parameters%type;

1510: parameter_list varchar2) return varchar2
1511: IS
1512: start_ptr number;
1513: end_ptr number;
1514: token_val pay_payroll_actions.legislative_parameters%type;
1515: par_value pay_payroll_actions.legislative_parameters%type;
1516:
1517: BEGIN
1518:

Line 1515: par_value pay_payroll_actions.legislative_parameters%type;

1511: IS
1512: start_ptr number;
1513: end_ptr number;
1514: token_val pay_payroll_actions.legislative_parameters%type;
1515: par_value pay_payroll_actions.legislative_parameters%type;
1516:
1517: BEGIN
1518:
1519: token_val := name||'=';