APPS.PAY_JP_UITE_REPORT_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 561: FROM pay_assignment_actions PAA,

557: hr_utility.set_location ('ln_pact_id .. '||ln_pact_id,20);
558: --
559: SELECT PAA1.assignment_action_id
560: INTO ln_old_assact_id
561: FROM pay_assignment_actions PAA,
562: pay_assignment_actions PAA1
563: WHERE PAA.assignment_action_id = ln_cur_assact
564: AND PAA.assignment_id = PAA1.assignment_id
565: AND PAA1.payroll_action_id = ln_pact_id;

Line 562: pay_assignment_actions PAA1

558: --
559: SELECT PAA1.assignment_action_id
560: INTO ln_old_assact_id
561: FROM pay_assignment_actions PAA,
562: pay_assignment_actions PAA1
563: WHERE PAA.assignment_action_id = ln_cur_assact
564: AND PAA.assignment_id = PAA1.assignment_id
565: AND PAA1.payroll_action_id = ln_pact_id;
566: --

Line 695: ,pay_assignment_actions PAS

691: SELECT DISTINCT PJUIEV.assignment_id
692: ,PJUIEV.termination_date
693: FROM per_assignments_f PAA
694: ,per_people_f PAP
695: ,pay_assignment_actions PAS
696: ,pay_jp_uite_emp_v PJUIEV
697: ,per_periods_of_service PPOF
698: ,pay_population_ranges PPR
699: ,pay_payroll_actions PPA

Line 728: ,pay_assignment_actions PAS

724: SELECT DISTINCT PJUIEV.assignment_id
725: ,PJUIEV.termination_date
726: FROM per_assignments_f PAA
727: ,per_people_f PAP
728: ,pay_assignment_actions PAS
729: ,pay_jp_uite_emp_v PJUIEV
730: ,per_periods_of_service PPOF
731: ,hr_all_organization_units HAOU
732: WHERE PAA.person_id = PAP.person_id

Line 748: ln_assact pay_assignment_actions.assignment_action_id%TYPE ;

744: AND TRUNC(NVL(PPOF.actual_termination_date,PPOF.projected_termination_date)) BETWEEN PAA.effective_start_date
745: AND PAA.effective_end_date; -- Bug 9728577
746:
747: --
748: ln_assact pay_assignment_actions.assignment_action_id%TYPE ;
749: lc_proc_name VARCHAR2(60);
750: lc_legislative_parameters VARCHAR2(2000);
751: ln_old_pact_id NUMBER;
752: ln_ass_set_id NUMBER;

Line 804: SELECT pay_assignment_actions_s.nextval

800: IF (NVL(ln_ass_set_id ,0) = 0) THEN
801: -- NO assignment set passed as parameter
802: hr_utility.trace ('ass_id = '||lr_assact.assignment_id);
803: --
804: SELECT pay_assignment_actions_s.nextval
805: INTO ln_assact
806: FROM dual;
807: hr_nonrun_asact.insact (ln_assact
808: ,lr_assact.assignment_id

Line 822: SELECT pay_assignment_actions_s.nextval

818: ,p_populate_fs_flag => 'Y' -- added for the bug #9652329
819: );
820: IF lc_include_flag = 'Y' THEN
821: --
822: SELECT pay_assignment_actions_s.nextval
823: INTO ln_assact
824: FROM dual;
825: hr_nonrun_asact.insact (ln_assact
826: ,lr_assact.assignment_id

Line 852: SELECT pay_assignment_actions_s.nextval

848: IF (NVL(ln_ass_set_id ,0) = 0) THEN
849: -- NO assignment set passed as parameter
850: hr_utility.trace ('ass_id = '||lr_assact.assignment_id);
851: --
852: SELECT pay_assignment_actions_s.nextval
853: INTO ln_assact
854: FROM dual;
855: hr_nonrun_asact.insact( ln_assact
856: ,lr_assact.assignment_id

Line 868: SELECT pay_assignment_actions_s.nextval

864: ,p_assignment_id => lr_assact.assignment_id
865: ,p_effective_date => lr_assact.termination_date
866: );
867: IF lc_include_flag = 'Y' THEN
868: SELECT pay_assignment_actions_s.nextval
869: INTO ln_assact
870: FROM dual;
871: hr_nonrun_asact.insact( ln_assact
872: ,lr_assact.assignment_id

Line 1090: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

1086: l_sal_xml CLOB;
1087: l_term_xml CLOB;
1088: l_wage_xml CLOB;
1089: l_xml_begin VARCHAR2(200);
1090: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1091: seque NUMBER;
1092: lc_insured_number VARCHAR2(4000);
1093: lc_location_number VARCHAR2(4000);
1094: ln_termination_value NUMBER;

Line 1590: ,pay_assignment_actions PAA

1586: END IF;
1587:
1588: sqlstr := ' SELECT PAA.rowid
1589: FROM per_assignments_f PAF
1590: ,pay_assignment_actions PAA
1591: ,per_people_f PPF
1592: ,hr_all_organization_units_tl HAOUT
1593: ,hr_all_organization_units HAOU
1594: ,per_periods_of_service PPS