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_PAYROLL_ACTIONS

Line 86: from pay_payroll_actions ppa

82: effective_date,
83: start_date,
84: business_group_id,
85: report_type
86: from pay_payroll_actions ppa
87: where ppa.payroll_action_id = cp_payroll_action_id;
88:
89: ld_end_date DATE;
90: ld_start_date DATE;

Line 179: from pay_payroll_actions ppa

175: report_qualifier,
176: report_category,
177: pay_ca_eoy_t4a_cancel_pkg.get_parameter(
178: 'PRINT_TERM',ppa.legislative_parameters)
179: from pay_payroll_actions ppa
180: where ppa.payroll_action_id = cp_payroll_action_id;
181:
182: ld_end_date DATE;
183: ld_start_date DATE;

Line 190: lv_report_qualifier pay_payroll_actions.report_qualifier%type;

186: ln_person_id NUMBER := 0;
187: ln_asg_set NUMBER := 0;
188: lv_print varchar2(10);
189: lv_report_type varchar2(50);
190: lv_report_qualifier pay_payroll_actions.report_qualifier%type;
191: lv_report_cat pay_payroll_actions.report_category%type;
192: l_print_term varchar2(1) := 'N';
193:
194: BEGIN

Line 191: lv_report_cat pay_payroll_actions.report_category%type;

187: ln_asg_set NUMBER := 0;
188: lv_print varchar2(10);
189: lv_report_type varchar2(50);
190: lv_report_qualifier pay_payroll_actions.report_qualifier%type;
191: lv_report_cat pay_payroll_actions.report_category%type;
192: l_print_term varchar2(1) := 'N';
193:
194: BEGIN
195: hr_utility.trace('Entered get_payroll_action_info');

Line 317: from pay_payroll_actions ppa_rep,

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

Line 320: pay_payroll_actions ppa

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

Line 335: from pay_payroll_actions ppa_rep,

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

Line 338: pay_payroll_actions ppa

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

Line 393: lv_report_type pay_payroll_actions.report_type%TYPE ;

389: ln_set_person_id NUMBER := 0 ;
390: ln_asg_set NUMBER := 0 ;
391: lv_print varchar2(10);
392:
393: lv_report_type pay_payroll_actions.report_type%TYPE ;
394:
395: -- Variables declared for bug 10399514
396: l_person_on boolean ;
397: l_report_cat pay_payroll_actions.report_category%type;

Line 397: l_report_cat pay_payroll_actions.report_category%type;

393: lv_report_type pay_payroll_actions.report_type%TYPE ;
394:
395: -- Variables declared for bug 10399514
396: l_person_on boolean ;
397: l_report_cat pay_payroll_actions.report_category%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:

Line 398: l_state pay_payroll_actions.report_qualifier%type;

394:
395: -- Variables declared for bug 10399514
396: l_person_on boolean ;
397: l_report_cat pay_payroll_actions.report_category%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;

Line 413: lv_prev_report_type pay_payroll_actions.report_type%TYPE;

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

Line 430: pay_payroll_actions ppa,

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

Line 453: pay_payroll_actions ppa,

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

Line 487: FROM pay_payroll_actions ppa ,

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

Line 502: from pay_payroll_actions ppa_rep,

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

Line 525: from pay_payroll_actions ppa_rep,

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

Line 557: from pay_payroll_actions ppa,

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

Line 579: pay_payroll_actions ppa1

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

Line 588: pay_payroll_actions ppa2

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
592: and paa2.tax_unit_id = paa.tax_unit_id

Line 611: from pay_payroll_actions ppa,

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

Line 630: pay_payroll_actions ppa1,

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

Line 641: pay_payroll_actions ppa2

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
645: and paa2.tax_unit_id = paa.tax_unit_id

Line 665: from pay_payroll_actions ppa,

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

Line 688: pay_payroll_actions ppa1

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

Line 697: pay_payroll_actions ppa2

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
701: and paa2.tax_unit_id = paa.tax_unit_id

Line 722: from pay_payroll_actions ppa,

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

Line 742: pay_payroll_actions ppa1,

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

Line 753: pay_payroll_actions ppa2

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
757: and paa2.tax_unit_id = paa.tax_unit_id

Line 1438: l_bg_id pay_payroll_actions.business_group_id%type ;

1434: l_year_start date;
1435: l_year_end date;
1436: l_print varchar2(20);
1437: l_asg_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;
1438: l_bg_id pay_payroll_actions.business_group_id%type ;
1439:
1440: begin
1441:
1442: begin

Line 1465: from pay_payroll_actions ppa

1461: l_print,
1462: l_year_end,
1463: l_year_start,
1464: l_bg_id
1465: from pay_payroll_actions ppa
1466: where ppa.payroll_action_id = payactid;
1467:
1468: exception
1469: when no_data_found then

Line 1487: pay_payroll_actions ppa1

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

Line 1538: token_val pay_payroll_actions.legislative_parameters%type;

1534: parameter_list varchar2) return varchar2
1535: IS
1536: start_ptr number;
1537: end_ptr number;
1538: token_val pay_payroll_actions.legislative_parameters%type;
1539: par_value pay_payroll_actions.legislative_parameters%type;
1540:
1541: BEGIN
1542:

Line 1539: par_value pay_payroll_actions.legislative_parameters%type;

1535: IS
1536: start_ptr number;
1537: end_ptr number;
1538: token_val pay_payroll_actions.legislative_parameters%type;
1539: par_value pay_payroll_actions.legislative_parameters%type;
1540:
1541: BEGIN
1542:
1543: token_val := name||'=';