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

Line 78: from pay_payroll_actions ppa

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

Line 167: from pay_payroll_actions ppa

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

Line 311: from pay_payroll_actions ppa_rep,

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

Line 314: pay_payroll_actions ppa

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

Line 329: from pay_payroll_actions ppa_rep,

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

Line 332: pay_payroll_actions ppa

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

Line 388: lv_report_type pay_payroll_actions.report_type%TYPE ;

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

Line 400: lv_prev_report_type pay_payroll_actions.report_type%TYPE;

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

Line 410: l_report_cat pay_payroll_actions.report_category%type;

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

Line 411: l_state pay_payroll_actions.report_qualifier%type;

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

Line 423: pay_payroll_actions ppa,

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

Line 446: pay_payroll_actions ppa,

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

Line 479: FROM pay_payroll_actions ppa ,

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

Line 494: from pay_payroll_actions ppa_rep,

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

Line 517: from pay_payroll_actions ppa_rep,

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

Line 548: from pay_payroll_actions ppa,

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

Line 571: pay_payroll_actions ppa1

567: 'CAEOY_RL2_NEGATIVE_BALANCE_EXISTS'),'N') = 'N'
568: and not exists (select 1
569: from pay_action_interlocks pai,
570: pay_assignment_actions paa1,
571: pay_payroll_actions ppa1
572: where pai.locked_action_id = paa.assignment_action_id
573: and pai.locking_action_id = paa1.assignment_action_id
574: and ppa1.effective_date = ppa.effective_date
575: and paa1.tax_unit_id = paa.tax_unit_id

Line 581: pay_payroll_actions ppa1

577: and ppa1.report_type = 'PAYCARL2CLPDF')
578: and not exists
579: (select 1
580: from pay_assignment_actions paa1,
581: pay_payroll_actions ppa1
582: where ppa1.report_type in ('RL2PAPERPDF','PAYCARL2AMPDF')
583: and ppa1.payroll_action_id = paa1.payroll_action_id
584: and ppa1.effective_date = ppa.effective_date
585: and substr(paa1.serial_number,1,2) = substr(paa.serial_number,1,2)

Line 603: from pay_payroll_actions ppa,

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

Line 620: pay_payroll_actions ppa1,

616: and ppa.report_type in ('RL2PAPERPDF','PAYCARL2AMPDF')
617: and exists
618: ( SELECT pail.locked_action_id
619: FROM pay_action_interlocks pail,
620: pay_payroll_actions ppa1,
621: pay_assignment_actions paa1
622: WHERE ppa1.report_type = 'PAYCARL2CLPDF'
623: AND ppa1.payroll_action_id = paa1.payroll_action_id
624: AND ppa1.effective_date = cp_effective_date

Line 632: pay_payroll_actions ppa1

628: AND pail.locked_action_id = paa.assignment_action_id)
629: and not exists
630: (select 1
631: from pay_assignment_actions paa1,
632: pay_payroll_actions ppa1
633: where ppa1.report_type in ('RL2PAPERPDF','PAYCARL2AMPDF')
634: and ppa1.payroll_action_id = paa1.payroll_action_id
635: and ppa1.effective_date = ppa.effective_date
636: and substr(paa1.serial_number,1,2) = substr(paa.serial_number,1,2)

Line 655: from pay_payroll_actions ppa,

651: paa.assignment_action_id,
652: paa.tax_unit_id,
653: paa.serial_number,
654: paf.effective_end_date
655: from pay_payroll_actions ppa,
656: pay_assignment_actions paa,
657: per_assignments_f paf,
658: per_periods_of_service pds
659: where paf.person_id = to_char(cp_person_id)

Line 679: pay_payroll_actions ppa1

675: 'CAEOY_RL2_NEGATIVE_BALANCE_EXISTS'),'N') = 'N'
676: and not exists (select 1
677: from pay_action_interlocks pai,
678: pay_assignment_actions paa1,
679: pay_payroll_actions ppa1
680: where pai.locked_action_id = paa.assignment_action_id
681: and pai.locking_action_id = paa1.assignment_action_id
682: and ppa1.effective_date = ppa.effective_date
683: and paa1.tax_unit_id = paa.tax_unit_id

Line 689: pay_payroll_actions ppa1

685: and ppa1.report_type = 'PAYCARL2CLPDF')
686: and not exists
687: (select 1
688: from pay_assignment_actions paa1,
689: pay_payroll_actions ppa1
690: where ppa1.report_type in ('RL2PAPERPDF','PAYCARL2AMPDF')
691: and ppa1.payroll_action_id = paa1.payroll_action_id
692: and ppa1.effective_date = ppa.effective_date
693: and substr(paa1.serial_number,1,2) = substr(paa.serial_number,1,2)

Line 713: from pay_payroll_actions ppa,

709: paa.assignment_action_id,
710: paa.tax_unit_id,
711: paa.serial_number,
712: paf.effective_end_date
713: from pay_payroll_actions ppa,
714: pay_assignment_actions paa,
715: per_assignments_f paf,
716: per_periods_of_service pds
717: where paf.person_id = to_char(cp_person_id)

Line 731: pay_payroll_actions ppa1,

727: and ppa.report_type in ('RL2PAPERPDF','PAYCARL2AMPDF')
728: and exists
729: ( SELECT pail.locked_action_id
730: FROM pay_action_interlocks pail,
731: pay_payroll_actions ppa1,
732: pay_assignment_actions paa1
733: WHERE ppa1.report_type = 'PAYCARL2CLPDF'
734: AND ppa1.payroll_action_id = paa1.payroll_action_id
735: AND ppa1.effective_date = cp_effective_date

Line 743: pay_payroll_actions ppa1

739: AND pail.locked_action_id = paa.assignment_action_id)
740: and not exists
741: (select 1
742: from pay_assignment_actions paa1,
743: pay_payroll_actions ppa1
744: where ppa1.report_type in ('RL2PAPERPDF','PAYCARL2AMPDF')
745: and ppa1.payroll_action_id = paa1.payroll_action_id
746: and ppa1.effective_date = ppa.effective_date
747: and substr(paa1.serial_number,1,2) = substr(paa.serial_number,1,2)

Line 1375: l_bg_id pay_payroll_actions.business_group_id%type ;

1371: l_year_start date;
1372: l_year_end date;
1373: l_print varchar2(20);
1374: l_asg_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;
1375: l_bg_id pay_payroll_actions.business_group_id%type ;
1376:
1377: begin
1378:
1379: begin

Line 1402: from pay_payroll_actions ppa

1398: l_print,
1399: l_year_end,
1400: l_year_start,
1401: l_bg_id
1402: from pay_payroll_actions ppa
1403: where ppa.payroll_action_id = payactid;
1404:
1405: exception when no_data_found then
1406: hr_utility.trace('Error in Sort Procedure - getting legislative param');

Line 1424: pay_payroll_actions ppa1

1420: hr_locations_all loc,
1421: per_all_people_f ppf,
1422: per_all_assignments_f paf,
1423: pay_assignment_actions paa1,
1424: pay_payroll_actions ppa1
1425: where ppa1.payroll_action_id = :p_payroll_action_id
1426: and paa1.payroll_action_id = ppa1.payroll_action_id
1427: and paa1.assignment_id = paf.assignment_id
1428: and paf.effective_start_date =

Line 1475: token_val pay_payroll_actions.legislative_parameters%type;

1471: parameter_list varchar2) return varchar2
1472: IS
1473: start_ptr number;
1474: end_ptr number;
1475: token_val pay_payroll_actions.legislative_parameters%type;
1476: par_value pay_payroll_actions.legislative_parameters%type;
1477:
1478: BEGIN
1479:

Line 1476: par_value pay_payroll_actions.legislative_parameters%type;

1472: IS
1473: start_ptr number;
1474: end_ptr number;
1475: token_val pay_payroll_actions.legislative_parameters%type;
1476: par_value pay_payroll_actions.legislative_parameters%type;
1477:
1478: BEGIN
1479:
1480: token_val := parameter_name||'=';