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

Line 80: from pay_payroll_actions ppa

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

Line 169: from pay_payroll_actions ppa

165: report_qualifier,
166: report_category,
167: pay_ca_eoy_rl1_cancelled_pkg.get_parameter(
168: 'PRINT_TERM',ppa.legislative_parameters)
169: from pay_payroll_actions ppa
170: where ppa.payroll_action_id = cp_payroll_action_id;
171:
172: ld_end_date DATE;
173: ld_start_date DATE;

Line 312: from pay_payroll_actions ppa_rep,

308: elsif ln_tax_unit_id is not NULL then
309:
310: lv_sql_string :=
311: 'select distinct paf.person_id
312: from pay_payroll_actions ppa_rep,
313: pay_assignment_actions paa_rep,
314: per_assignments_f paf,
315: pay_payroll_actions ppa
316: where paa_rep.assignment_id = paf.assignment_id

Line 315: pay_payroll_actions ppa

311: 'select distinct paf.person_id
312: from pay_payroll_actions ppa_rep,
313: pay_assignment_actions paa_rep,
314: per_assignments_f paf,
315: pay_payroll_actions ppa
316: where paa_rep.assignment_id = paf.assignment_id
317: and ppa.payroll_action_id = :payroll_action_id
318: and ppa_rep.business_group_id = ppa.business_group_id
319: and ppa_rep.effective_date = ppa.effective_date

Line 330: from pay_payroll_actions ppa_rep,

326: else
327:
328: lv_sql_string :=
329: 'select distinct paf.person_id
330: from pay_payroll_actions ppa_rep,
331: pay_assignment_actions paa_rep,
332: per_assignments_f paf,
333: pay_payroll_actions ppa
334: where paa_rep.assignment_id = paf.assignment_id

Line 333: pay_payroll_actions ppa

329: 'select distinct paf.person_id
330: from pay_payroll_actions ppa_rep,
331: pay_assignment_actions paa_rep,
332: per_assignments_f paf,
333: pay_payroll_actions ppa
334: where paa_rep.assignment_id = paf.assignment_id
335: and ppa.payroll_action_id = :payroll_action_id
336: and ppa_rep.business_group_id = ppa.business_group_id
337: and ppa_rep.effective_date = ppa.effective_date

Line 389: lv_report_type pay_payroll_actions.report_type%TYPE ;

385: ln_asg_set NUMBER := 0 ;
386: lv_print varchar2(10);
387: lv_prov_cd varchar2(5);
388:
389: lv_report_type pay_payroll_actions.report_type%TYPE ;
390: ln_rep_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
391: ln_arch_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
392: ln_second_last_arch_action pay_assignment_actions.assignment_action_id%TYPE;
393: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;

Line 401: lv_prev_report_type pay_payroll_actions.report_type%TYPE;

397: lv_employee_number per_people_f.employee_number%type;
398: lv_message varchar2(240):= null;
399: lv_full_name per_people_f.full_name%type;
400: lv_record_name varchar2(100);
401: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
402: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
403: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;
404: ln_serial_number pay_assignment_actions.serial_number%TYPE;
405: ln_pre_id NUMBER;

Line 411: l_report_cat pay_payroll_actions.report_category%type;

407: lv_ppr_report_type varchar2(50);
408:
409: -- Variables declared for bug 10399514
410: l_person_on boolean ;
411: l_report_cat pay_payroll_actions.report_category%type;
412: l_state pay_payroll_actions.report_qualifier%type;
413: l_report_format pay_report_format_mappings_f.report_format%type;
414: -- Variables declared for bug 10399514
415: l_print_term varchar2(1);

Line 412: l_state pay_payroll_actions.report_qualifier%type;

408:
409: -- Variables declared for bug 10399514
410: l_person_on boolean ;
411: l_report_cat pay_payroll_actions.report_category%type;
412: l_state pay_payroll_actions.report_qualifier%type;
413: l_report_format pay_report_format_mappings_f.report_format%type;
414: -- Variables declared for bug 10399514
415: l_print_term varchar2(1);
416:

Line 424: pay_payroll_actions ppa,

420: ,cp_effective_date in date) is
421: select distinct paf.person_id
422: from hr_assignment_set_amendments asgset,
423: per_assignments_f paf,
424: pay_payroll_actions ppa,
425: pay_assignment_actions paa
426: where asgset.assignment_set_id = cp_asg_set
427: and asgset.include_or_exclude = 'I'
428: and paf.assignment_id = asgset.assignment_id

Line 447: pay_payroll_actions ppa,

443: ,cp_effective_date in date) is
444: select distinct paf.person_id
445: from hr_assignment_set_amendments asgset,
446: per_assignments_f paf,
447: pay_payroll_actions ppa,
448: pay_assignment_actions paa,
449: pay_population_ranges ppr
450: where asgset.assignment_set_id = cp_asg_set
451: and asgset.include_or_exclude = 'I'

Line 480: FROM pay_payroll_actions ppa ,

476: >= cp_eff_date
477: AND hoi.org_information_context = 'Prov Reporting Est'
478: AND hoi.org_information4 = 'P01'
479: AND exists ( SELECT 1
480: FROM pay_payroll_actions ppa ,
481: pay_assignment_actions paa
482: WHERE ppa.report_type in ('RL1PAPERPDF','PAYCARL1AMPDF')
483: AND ppa.report_qualifier = 'DEFAULT'
484: AND ppa.business_group_id = cp_bg_id

Line 495: from pay_payroll_actions ppa_rep,

491: cp_eff_date date,
492: cp_start_person number,
493: cp_end_person number) is
494: select distinct paf.person_id
495: from pay_payroll_actions ppa_rep,
496: pay_assignment_actions paa_rep,
497: per_assignments_f paf
498: where ppa_rep.business_group_id = cp_bg_id
499: and ppa_rep.report_type in ('RL1PAPERPDF','PAYCARL1AMPDF')

Line 518: from pay_payroll_actions ppa_rep,

514: cp_eff_date date,
515: cp_start_person number,
516: cp_end_person number) is
517: select distinct paf.person_id
518: from pay_payroll_actions ppa_rep,
519: pay_assignment_actions paa_rep,
520: per_assignments_f paf,
521: pay_population_ranges ppr
522: where ppa_rep.business_group_id = cp_bg_id

Line 550: from pay_payroll_actions ppa,

546: paa.assignment_action_id,
547: paa.tax_unit_id,
548: paa.serial_number,
549: paf.effective_end_date
550: from pay_payroll_actions ppa,
551: pay_assignment_actions paa,
552: per_assignments_f paf
553: where paf.person_id = to_char(cp_person_id)
554: and paf.assignment_id = paa.assignment_id

Line 576: pay_payroll_actions ppa1

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

Line 586: pay_payroll_actions ppa1

582: and ppa1.report_type = 'PAYCARL1CLPDF')
583: and not exists
584: (select 1
585: from pay_assignment_actions paa1,
586: pay_payroll_actions ppa1
587: where ppa1.report_type in ('RL1PAPERPDF','PAYCARL1AMPDF')
588: and ppa1.payroll_action_id = paa1.payroll_action_id
589: and ppa1.effective_date = ppa.effective_date
590: and substr(paa1.serial_number,1,2) = substr(paa.serial_number,1,2)

Line 608: from pay_payroll_actions ppa,

604: paa.assignment_action_id,
605: paa.tax_unit_id,
606: paa.serial_number,
607: paf.effective_end_date
608: from pay_payroll_actions ppa,
609: pay_assignment_actions paa,
610: per_assignments_f paf
611: where paf.person_id = to_char(cp_person_id)
612: and paf.assignment_id = paa.assignment_id

Line 628: pay_payroll_actions ppa1,

624: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
625: and exists
626: ( SELECT pail.locked_action_id
627: FROM pay_action_interlocks pail,
628: pay_payroll_actions ppa1,
629: pay_assignment_actions paa1
630: WHERE ppa1.report_type = 'PAYCARL1CLPDF'
631: AND ppa1.payroll_action_id = paa1.payroll_action_id
632: AND ppa1.effective_date = cp_effective_date

Line 640: pay_payroll_actions ppa1

636: AND pail.locked_action_id = paa.assignment_action_id)
637: and not exists
638: (select 1
639: from pay_assignment_actions paa1,
640: pay_payroll_actions ppa1
641: where ppa1.report_type in ('RL1PAPERPDF','PAYCARL1AMPDF')
642: and ppa1.payroll_action_id = paa1.payroll_action_id
643: and ppa1.effective_date = ppa.effective_date
644: and substr(paa1.serial_number,1,2) = substr(paa.serial_number,1,2)

Line 663: from pay_payroll_actions ppa,

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

Line 690: pay_payroll_actions ppa1

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

Line 700: pay_payroll_actions ppa1

696: and ppa1.report_type = 'PAYCARL1CLPDF')
697: and not exists
698: (select 1
699: from pay_assignment_actions paa1,
700: pay_payroll_actions ppa1
701: where ppa1.report_type in ('RL1PAPERPDF','PAYCARL1AMPDF')
702: and ppa1.payroll_action_id = paa1.payroll_action_id
703: and ppa1.effective_date = ppa.effective_date
704: and substr(paa1.serial_number,1,2) = substr(paa.serial_number,1,2)

Line 724: from pay_payroll_actions ppa,

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

Line 745: pay_payroll_actions ppa1,

741: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
742: and exists
743: ( SELECT pail.locked_action_id
744: FROM pay_action_interlocks pail,
745: pay_payroll_actions ppa1,
746: pay_assignment_actions paa1
747: WHERE ppa1.report_type = 'PAYCARL1CLPDF'
748: AND ppa1.payroll_action_id = paa1.payroll_action_id
749: AND ppa1.effective_date = cp_effective_date

Line 757: pay_payroll_actions ppa1

753: AND pail.locked_action_id = paa.assignment_action_id)
754: and not exists
755: (select 1
756: from pay_assignment_actions paa1,
757: pay_payroll_actions ppa1
758: where ppa1.report_type in ('RL1PAPERPDF','PAYCARL1AMPDF')
759: and ppa1.payroll_action_id = paa1.payroll_action_id
760: and ppa1.effective_date = ppa.effective_date
761: and substr(paa1.serial_number,1,2) = substr(paa.serial_number,1,2)

Line 1389: l_bg_id pay_payroll_actions.business_group_id%type ;

1385: l_year_start date;
1386: l_year_end date;
1387: l_print varchar2(20);
1388: l_asg_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;
1389: l_bg_id pay_payroll_actions.business_group_id%type ;
1390:
1391: begin
1392:
1393: begin

Line 1416: from pay_payroll_actions ppa

1412: l_print,
1413: l_year_end,
1414: l_year_start,
1415: l_bg_id
1416: from pay_payroll_actions ppa
1417: where ppa.payroll_action_id = payactid;
1418:
1419: exception when no_data_found then
1420: hr_utility.trace('Error in Sort Procedure - getting legislative param');

Line 1438: pay_payroll_actions ppa1

1434: hr_locations_all loc,
1435: per_all_people_f ppf,
1436: per_all_assignments_f paf,
1437: pay_assignment_actions paa1,
1438: pay_payroll_actions ppa1
1439: where ppa1.payroll_action_id = :p_payroll_action_id
1440: and paa1.payroll_action_id = ppa1.payroll_action_id
1441: and paa1.assignment_id = paf.assignment_id
1442: and paf.effective_start_date =

Line 1489: token_val pay_payroll_actions.legislative_parameters%type;

1485: parameter_list varchar2) return varchar2
1486: IS
1487: start_ptr number;
1488: end_ptr number;
1489: token_val pay_payroll_actions.legislative_parameters%type;
1490: par_value pay_payroll_actions.legislative_parameters%type;
1491:
1492: BEGIN
1493:

Line 1490: par_value pay_payroll_actions.legislative_parameters%type;

1486: IS
1487: start_ptr number;
1488: end_ptr number;
1489: token_val pay_payroll_actions.legislative_parameters%type;
1490: par_value pay_payroll_actions.legislative_parameters%type;
1491:
1492: BEGIN
1493:
1494: token_val := parameter_name||'=';