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.PER_JP_WRKREG_REPORT_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 439: ,pay_assignment_actions PAA

435: initialize(p_payroll_action_id);
436: -- Bug 8691511
437: sqlstr := ' SELECT PAA.rowid
438: FROM per_assignments_f PAF
439: ,pay_assignment_actions PAA
440: ,per_people_f PPF
441: ,hr_all_organization_units_tl HAOUT
442: ,hr_all_organization_units HAOU
443: ,per_periods_of_service PPS

Line 605: ,pay_assignment_actions PAS

601: SELECT PJWREV.assignment_id
602: ,PJWREV.effective_date
603: FROM per_assignments_f PAA
604: ,per_people_f PAP
605: ,pay_assignment_actions PAS
606: ,per_jp_wrkreg_emp_v PJWREV
607: ,per_periods_of_service PPOF
608: ,pay_population_ranges PPR
609: ,pay_payroll_actions PPA

Line 661: ,pay_assignment_actions PAS

657: SELECT PJWREV.assignment_id
658: ,PJWREV.effective_date
659: FROM per_assignments_f PAA
660: ,per_people_f PAP
661: ,pay_assignment_actions PAS
662: ,per_jp_wrkreg_emp_v PJWREV
663: ,per_periods_of_service PPOF
664: ,hr_all_organization_units HAOU
665: WHERE PAA.person_id = PAP.person_id

Line 699: ln_assact pay_assignment_actions.assignment_action_id%TYPE ;

695: OR (PPOF.actual_termination_date > = p_effective_date AND p_effective_date > = PPOF.DATE_START ))
696: )
697: );
698: --
699: ln_assact pay_assignment_actions.assignment_action_id%TYPE ;
700: lc_proc_name VARCHAR2(60);
701: lc_legislative_parameters VARCHAR2(2000);
702: lc_result1 VARCHAR2(30);
703: ln_old_pact_id NUMBER;

Line 775: SELECT pay_assignment_actions_s.nextval

771: IF (NVL(ln_ass_set_id ,0) = 0) THEN
772: -- NO assignment set passed as parameter
773: hr_utility.trace ('ass_id = '||lr_assact.assignment_id);
774: --
775: SELECT pay_assignment_actions_s.nextval
776: INTO ln_assact
777: FROM dual;
778: hr_nonrun_asact.insact(ln_assact
779: ,lr_assact.assignment_id

Line 792: SELECT pay_assignment_actions_s.nextval

788: ,p_effective_date => gr_parameters.effective_date
789: );
790: IF lc_include_flag = 'Y' THEN
791: --
792: SELECT pay_assignment_actions_s.nextval
793: INTO ln_assact
794: FROM dual;
795: hr_nonrun_asact.insact(ln_assact
796: ,lr_assact.assignment_id

Line 829: SELECT pay_assignment_actions_s.nextval

825: IF (NVL(ln_ass_set_id ,0) = 0) THEN
826: -- NO assignment set passed as parameter
827: hr_utility.trace ('ass_id = '||lr_assact.assignment_id);
828: --
829: SELECT pay_assignment_actions_s.nextval
830: INTO ln_assact
831: FROM dual;
832: hr_nonrun_asact.insact(ln_assact
833: ,lr_assact.assignment_id

Line 846: SELECT pay_assignment_actions_s.nextval

842: ,p_effective_date => gr_parameters.effective_date
843: );
844: IF lc_include_flag = 'Y' THEN
845: --
846: SELECT pay_assignment_actions_s.nextval
847: INTO ln_assact
848: FROM dual;
849: hr_nonrun_asact.insact(ln_assact
850: ,lr_assact.assignment_id

Line 885: SELECT pay_assignment_actions_s.nextval

881: IF (NVL(ln_ass_set_id ,0) = 0) THEN
882: -- NO assignment set passed as parameter
883: hr_utility.trace ('ass_id = '||lr_assact.assignment_id);
884: --
885: SELECT pay_assignment_actions_s.nextval
886: INTO ln_assact
887: FROM dual;
888: hr_nonrun_asact.insact(ln_assact
889: ,lr_assact.assignment_id

Line 902: SELECT pay_assignment_actions_s.nextval

898: ,p_effective_date => gr_parameters.effective_date
899: );
900: IF lc_include_flag = 'Y' THEN
901: --
902: SELECT pay_assignment_actions_s.nextval
903: INTO ln_assact
904: FROM dual;
905: hr_nonrun_asact.insact(ln_assact
906: ,lr_assact.assignment_id

Line 937: SELECT pay_assignment_actions_s.nextval

933: IF (NVL(ln_ass_set_id ,0) = 0) THEN
934: -- NO assignment set passed as parameter
935: hr_utility.trace ('ass_id = '||lr_assact.assignment_id);
936: --
937: SELECT pay_assignment_actions_s.nextval
938: INTO ln_assact
939: FROM dual;
940: hr_nonrun_asact.insact(ln_assact
941: ,lr_assact.assignment_id

Line 954: SELECT pay_assignment_actions_s.nextval

950: ,p_effective_date => gr_parameters.effective_date
951: );
952: IF lc_include_flag = 'Y' THEN
953: --
954: SELECT pay_assignment_actions_s.nextval
955: INTO ln_assact
956: FROM dual;
957: hr_nonrun_asact.insact(ln_assact
958: ,lr_assact.assignment_id

Line 1189: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

1185: l_xml CLOB;
1186: l_xml2 CLOB;
1187: l_common_xml CLOB;
1188: l_xml_begin VARCHAR2(200);
1189: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1190: l_emp_no VARCHAR2(80);
1191: l_job_hist_xml CLOB ;
1192: l_additional_info_xml CLOB;
1193: l_add_msg_xml CLOB;

Line 1674: FROM pay_assignment_actions PAA,

1670: ln_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ACTION_ID',lc_legislative_parameters));
1671: --
1672: SELECT PAA1.assignment_action_id
1673: INTO ln_old_assact_id
1674: FROM pay_assignment_actions PAA,
1675: pay_assignment_actions PAA1
1676: WHERE PAA.assignment_action_id = ln_cur_assact
1677: AND PAA.assignment_id = PAA1.assignment_id
1678: AND PAA1.payroll_action_id = ln_pact_id;

Line 1675: pay_assignment_actions PAA1

1671: --
1672: SELECT PAA1.assignment_action_id
1673: INTO ln_old_assact_id
1674: FROM pay_assignment_actions PAA,
1675: pay_assignment_actions PAA1
1676: WHERE PAA.assignment_action_id = ln_cur_assact
1677: AND PAA.assignment_id = PAA1.assignment_id
1678: AND PAA1.payroll_action_id = ln_pact_id;
1679: --