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_ASSIGNMENT_ACTIONS

Line 259: ln_agent_tax_unit_id pay_assignment_actions.tax_unit_id%type;

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

Line 313: pay_assignment_actions paa_rep,

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

Line 331: pay_assignment_actions paa_rep,

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

Line 390: ln_rep_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;

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

Line 391: ln_arch_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;

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

Line 392: ln_second_last_arch_action pay_assignment_actions.assignment_action_id%TYPE;

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

Line 393: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;

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

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

Line 403: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;

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

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

Line 425: pay_assignment_actions paa

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

Line 448: pay_assignment_actions paa,

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

Line 481: pay_assignment_actions paa

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

Line 496: pay_assignment_actions paa_rep,

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

Line 519: pay_assignment_actions paa_rep,

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
523: and ppa_rep.report_type in ('RL1PAPERPDF','PAYCARL1AMPDF')

Line 551: pay_assignment_actions paa,

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
555: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)

Line 575: pay_assignment_actions paa1,

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

Line 585: from pay_assignment_actions paa1,

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

Line 609: pay_assignment_actions paa,

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
613: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)

Line 629: pay_assignment_actions paa1

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

Line 639: from pay_assignment_actions paa1,

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

Line 664: pay_assignment_actions paa,

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

Line 689: pay_assignment_actions paa1,

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

Line 699: from pay_assignment_actions paa1,

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

Line 725: pay_assignment_actions paa,

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

Line 746: pay_assignment_actions paa1

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

Line 756: from pay_assignment_actions paa1,

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

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

775: from per_people_f
776: where person_id = cp_person_id
777: order by effective_end_date desc;
778:
779: CURSOR check_arch_action_exists (p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) is
780: select 'Y'
781: from pay_assignment_actions
782: where assignment_action_id = p_assignment_action_id;
783:

Line 781: from pay_assignment_actions

777: order by effective_end_date desc;
778:
779: CURSOR check_arch_action_exists (p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) is
780: select 'Y'
781: from pay_assignment_actions
782: where assignment_action_id = p_assignment_action_id;
783:
784: CURSOR c_get_ue_id(cp_user_name varchar2) IS
785: select user_entity_id

Line 799: lv_serial_number pay_assignment_actions.serial_number%TYPE;

795: ln_yepp_pact_id number;
796: ln_pre_id_null number;
797: ln_iteration number :=0;
798: lv_flag_count number :=0;
799: lv_serial_number pay_assignment_actions.serial_number%TYPE;
800:
801:
802: lv_negative_bal_flag varchar2(10);
803: lv_neg_bal_mesg varchar2(100);

Line 948: select pay_assignment_actions_s.nextval

944: 'PRINT',
945: 'ASSIGNMENT',
946: ln_primary_assignment_id,
947: l_effective_end_date),'Y') = 'Y' then
948: select pay_assignment_actions_s.nextval
949: into ln_rl1_cancelled_asg_action
950: from dual;
951:
952: hr_utility.trace('New RL1 Amend Action = ' ||

Line 955: /* Insert into pay_assignment_actions. */

951:
952: hr_utility.trace('New RL1 Amend Action = ' ||
953: to_char(ln_rl1_cancelled_asg_action));
954:
955: /* Insert into pay_assignment_actions. */
956: hr_nonrun_asact.insact(ln_rl1_cancelled_asg_action
957: ,ln_primary_assignment_id
958: ,p_payroll_action_id
959: ,p_chunk

Line 984: update pay_assignment_actions aa

980: ln_serial_number := lv_prov_of_emp||
981: lpad(to_char(ln_arch_act_to_lock),14,0)||
982: lpad(to_char(ln_rep_act_to_lock),14,0);
983:
984: update pay_assignment_actions aa
985: set aa.serial_number = ln_serial_number
986: where aa.assignment_action_id = ln_rl1_cancelled_asg_action;
987:
988: hr_utility.trace('lv_prov_of_emp :'||substr(ln_serial_number,1,2));

Line 1097: select pay_assignment_actions_s.nextval

1093: 'PRINT',
1094: 'ASSIGNMENT',
1095: ln_primary_assignment_id,
1096: l_effective_end_date),'Y') = 'Y' then
1097: select pay_assignment_actions_s.nextval
1098: into ln_rl1_cancelled_asg_action
1099: from dual;
1100:
1101: hr_utility.trace('New RL1 Cancel Action = ' ||

Line 1104: /* Insert into pay_assignment_actions. */

1100:
1101: hr_utility.trace('New RL1 Cancel Action = ' ||
1102: to_char(ln_rl1_cancelled_asg_action));
1103:
1104: /* Insert into pay_assignment_actions. */
1105: hr_nonrun_asact.insact(ln_rl1_cancelled_asg_action
1106: ,ln_primary_assignment_id
1107: ,p_payroll_action_id
1108: ,p_chunk

Line 1130: update pay_assignment_actions aa

1126: ln_serial_number := lv_prov_of_emp||
1127: lpad(to_char(ln_arch_act_to_lock),14,0)||
1128: lpad(to_char(ln_rep_act_to_lock),14,0);
1129:
1130: update pay_assignment_actions aa
1131: set aa.serial_number = ln_serial_number
1132: where aa.assignment_action_id = ln_rl1_cancelled_asg_action;
1133: hr_utility.trace('lv_prov_of_emp :'||substr(ln_serial_number,1,2));
1134: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));

Line 1380: l_pre_id pay_assignment_actions.tax_unit_id%type;

1376: ) is
1377:
1378: l_dt date;
1379: l_year number ;
1380: l_pre_id pay_assignment_actions.tax_unit_id%type;
1381: l_per_id per_assignments_f.person_id%type;
1382: l_sort1 varchar2(60);
1383: l_sort2 varchar2(60);
1384: l_sort3 varchar2(60);

Line 1437: pay_assignment_actions paa1,

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