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_ASSIGNMENT_ACTIONS

Line 258: ln_agent_tax_unit_id pay_assignment_actions.tax_unit_id%type;

254: lv_sql_string VARCHAR2(32000);
255: ln_eoy_pactid number;
256: lv_print varchar2(10):=null;
257: lv_error_mesg varchar2(100);
258: ln_agent_tax_unit_id pay_assignment_actions.tax_unit_id%type;
259: ln_year number;
260: lv_prov_cd varchar2(5);
261: lv_report_type varchar2(50);
262:

Line 312: pay_assignment_actions paa_rep,

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
316: and ppa.payroll_action_id = :payroll_action_id

Line 330: pay_assignment_actions paa_rep,

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
334: and ppa.payroll_action_id = :payroll_action_id

Line 389: ln_rep_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;

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;
393:

Line 390: ln_arch_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;

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;
393:
394:

Line 391: ln_second_last_arch_action pay_assignment_actions.assignment_action_id%TYPE;

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;
393:
394:
395: lv_serial_number VARCHAR2(30);

Line 392: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;

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;
393:
394:
395: lv_serial_number VARCHAR2(30);
396: lv_employee_number per_people_f.employee_number%type;

Line 401: ln_prev_lock_action pay_assignment_actions.assignment_action_id%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;
405: ln_pre_parameter NUMBER;

Line 402: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;

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;
405: ln_pre_parameter NUMBER;
406: lv_ppr_report_type varchar2(50);

Line 403: ln_serial_number pay_assignment_actions.serial_number%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;
405: ln_pre_parameter NUMBER;
406: lv_ppr_report_type varchar2(50);
407:

Line 424: pay_assignment_actions paa

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
428: and paf.person_id between cp_start_person

Line 447: pay_assignment_actions paa,

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'
451: and paf.assignment_id = asgset.assignment_id

Line 480: pay_assignment_actions paa

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
484: AND ppa.effective_date = cp_eff_date

Line 495: pay_assignment_actions paa_rep,

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')
499: and ppa_rep.report_qualifier = 'DEFAULT'

Line 518: pay_assignment_actions paa_rep,

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
522: and ppa_rep.report_type in ('RL2PAPERPDF','PAYCARL2AMPDF')

Line 549: pay_assignment_actions paa,

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

Line 570: pay_assignment_actions paa1,

566: substr(paa.serial_number,1,2),'JURISDICTION_CODE',
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

Line 580: from pay_assignment_actions paa1,

576: and paa1.payroll_action_id = ppa1.payroll_action_id
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

Line 604: pay_assignment_actions paa,

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

Line 621: pay_assignment_actions paa1

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
625: AND paa1.assignment_action_id = pail.locking_action_id

Line 631: from pay_assignment_actions paa1,

627: AND paa1.assignment_id=paf.assignment_id
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

Line 656: pay_assignment_actions paa,

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)
660: and paf.assignment_id = paa.assignment_id

Line 678: pay_assignment_actions paa1,

674: substr(paa.serial_number,1,2),'JURISDICTION_CODE',
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

Line 688: from pay_assignment_actions paa1,

684: and paa1.payroll_action_id = ppa1.payroll_action_id
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

Line 714: pay_assignment_actions paa,

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)
718: and paf.assignment_id = paa.assignment_id

Line 732: pay_assignment_actions paa1

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
736: AND paa1.assignment_action_id = pail.locking_action_id

Line 742: from pay_assignment_actions paa1,

738: AND paa1.assignment_id=paf.assignment_id
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

Line 765: CURSOR check_arch_action_exists (p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) is

761: from per_people_f
762: where person_id = cp_person_id
763: order by effective_end_date desc;
764:
765: CURSOR check_arch_action_exists (p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) is
766: select 'Y'
767: from pay_assignment_actions
768: where assignment_action_id = p_assignment_action_id;
769:

Line 767: from pay_assignment_actions

763: order by effective_end_date desc;
764:
765: CURSOR check_arch_action_exists (p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) is
766: select 'Y'
767: from pay_assignment_actions
768: where assignment_action_id = p_assignment_action_id;
769:
770: CURSOR c_get_ue_id(cp_user_name varchar2) IS
771: select user_entity_id

Line 785: lv_serial_number pay_assignment_actions.serial_number%TYPE;

781: ln_yepp_pact_id number;
782: ln_pre_id_null number;
783: ln_iteration number :=0;
784: lv_flag_count number :=0;
785: lv_serial_number pay_assignment_actions.serial_number%TYPE;
786:
787:
788: lv_negative_bal_flag varchar2(10);
789: lv_neg_bal_mesg varchar2(100);

Line 935: select pay_assignment_actions_s.nextval

931: /* Create an assignment action for this person */
932: hr_utility.trace('get_latest_rl2_cancel_dtls found ');
933: hr_utility.trace('Report Type: '||lv_report_type);
934:
935: select pay_assignment_actions_s.nextval
936: into ln_rl2_cancel_asg_action
937: from dual;
938:
939: hr_utility.trace('New rl2 Amend Action = ' ||

Line 942: /* Insert into pay_assignment_actions. */

938:
939: hr_utility.trace('New rl2 Amend Action = ' ||
940: to_char(ln_rl2_cancel_asg_action));
941:
942: /* Insert into pay_assignment_actions. */
943: hr_nonrun_asact.insact(ln_rl2_cancel_asg_action
944: ,ln_primary_assignment_id
945: ,p_payroll_action_id
946: ,p_chunk

Line 971: update pay_assignment_actions aa

967: ln_serial_number := lv_prov_of_emp||
968: lpad(to_char(ln_arch_act_to_lock),14,0)||
969: lpad(to_char(ln_rep_act_to_lock),14,0);
970:
971: update pay_assignment_actions aa
972: set aa.serial_number = ln_serial_number
973: where aa.assignment_action_id = ln_rl2_cancel_asg_action;
974:
975: hr_utility.trace('lv_prov_of_emp :'||substr(ln_serial_number,1,2));

Line 1084: select pay_assignment_actions_s.nextval

1080: /* Create an assignment action for this person */
1081: hr_utility.trace('get_reprint_rl2amendpdf_dtls found ');
1082: hr_utility.trace('Report Type: '||lv_report_type);
1083:
1084: select pay_assignment_actions_s.nextval
1085: into ln_rl2_cancel_asg_action
1086: from dual;
1087:
1088: hr_utility.trace('New rl2 Cancel Action = ' ||

Line 1091: /* Insert into pay_assignment_actions. */

1087:
1088: hr_utility.trace('New rl2 Cancel Action = ' ||
1089: to_char(ln_rl2_cancel_asg_action));
1090:
1091: /* Insert into pay_assignment_actions. */
1092: hr_nonrun_asact.insact(ln_rl2_cancel_asg_action
1093: ,ln_primary_assignment_id
1094: ,p_payroll_action_id
1095: ,p_chunk

Line 1113: update pay_assignment_actions aa

1109: ln_serial_number := lv_prov_of_emp||
1110: lpad(to_char(ln_arch_act_to_lock),14,0)||
1111: lpad(to_char(ln_rep_act_to_lock),14,0);
1112:
1113: update pay_assignment_actions aa
1114: set aa.serial_number = ln_serial_number
1115: where aa.assignment_action_id = ln_rl2_cancel_asg_action;
1116: hr_utility.trace('lv_prov_of_emp :'||substr(ln_serial_number,1,2));
1117: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));

Line 1366: l_pre_id pay_assignment_actions.tax_unit_id%type;

1362: ) is
1363:
1364: l_dt date;
1365: l_year number ;
1366: l_pre_id pay_assignment_actions.tax_unit_id%type;
1367: l_per_id per_assignments_f.person_id%type;
1368: l_sort1 varchar2(60);
1369: l_sort2 varchar2(60);
1370: l_sort3 varchar2(60);

Line 1423: pay_assignment_actions paa1,

1419: hr_all_organization_units hou1,
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