APPS.PAY_IE_P35 dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 86: FROM per_assignment_extra_info

82:
83: CURSOR csr_ppsn_override(p_asg_id NUMBER)
84: IS
85: SELECT aei_information1 PPSN_OVERRIDE
86: FROM per_assignment_extra_info
87: WHERE assignment_id = p_asg_id
88: AND aei_information_category = 'IE_ASG_OVERRIDE';
89:
90: l_ppsn_override varchar2(100);

Line 949: from per_assignment_extra_info

945: --6633719
946: cursor csr_ppsn_override(p_asg_id number)
947: is
948: select aei_information1 PPSN_OVERRIDE
949: from per_assignment_extra_info
950: where assignment_id = p_asg_id
951: and aei_information_category = 'IE_ASG_OVERRIDE';
952:
953: l_ppsn_override per_assignment_extra_info.aei_information1%type;

Line 953: l_ppsn_override per_assignment_extra_info.aei_information1%type;

949: from per_assignment_extra_info
950: where assignment_id = p_asg_id
951: and aei_information_category = 'IE_ASG_OVERRIDE';
952:
953: l_ppsn_override per_assignment_extra_info.aei_information1%type;
954:
955: cursor csr_ppsn_max_asg(p_ppsn_override varchar2, p_person_id number)
956: is
957: select MAX(paei.assignment_id) ovrride_asg

Line 958: from per_assignment_extra_info paei

954:
955: cursor csr_ppsn_max_asg(p_ppsn_override varchar2, p_person_id number)
956: is
957: select MAX(paei.assignment_id) ovrride_asg
958: from per_assignment_extra_info paei
959: where paei.information_type = 'IE_ASG_OVERRIDE'
960: and paei.aei_information1 = p_ppsn_override
961: and exists
962: (select 1 from per_all_assignments_f paaf

Line 967: l_ppsn_override_asg per_assignment_extra_info.assignment_id%type;

963: where paaf.assignment_id = paei.assignment_id
964: and paaf.person_id = p_person_id)
965: GROUP BY paei.aei_information1;
966:
967: l_ppsn_override_asg per_assignment_extra_info.assignment_id%type;
968:
969: --6633719
970:
971: /* --8322991

Line 2457: FROM per_assignments_f paf, per_assignment_extra_info paei

2453: WHERE paf.period_of_service_id = p_pds_id
2454: AND paf.person_id=c_person_id))
2455: OR
2456: (c_ppsn is not null and paa.assignment_id in (SELECT paf.assignment_id
2457: FROM per_assignments_f paf, per_assignment_extra_info paei
2458: WHERE paf.period_of_service_id = p_pds_id
2459: AND paf.person_id=c_person_id
2460: AND paf.assignment_id=paei.assignment_id
2461: AND paei.information_type = 'IE_ASG_OVERRIDE'

Line 2508: from per_assignments_f paf, per_assignment_extra_info paei

2504: --6633719
2505: /* Cursor to fetch primary flag for terminated assignments for PPSN OVERRIDE case*/
2506: CURSOR csr_get_primary_flag1(p_ppsn_override varchar2) is
2507: select NVL (SUBSTR (paf.assignment_number, 1, 12), ' ') -- WORKS NUMBER
2508: from per_assignments_f paf, per_assignment_extra_info paei
2509: where paf.assignment_id = paei.assignment_id
2510: and aei_information1 = p_ppsn_override
2511: and paf.effective_start_date <= l_end_date
2512: and paf.effective_end_date >= l_start_date

Line 2520: per_assignment_extra_info paei

2516: /* Cursor to fetch primary flag for active assignments PPSN OVERRIDE case*/
2517: CURSOR csr_get_primary_flag_active1(p_ppsn_override varchar2) is
2518: select NVL (SUBSTR (paf.assignment_number, 1, 12), ' ') -- WORKS NUMBER
2519: from per_assignments_f paf,
2520: per_assignment_extra_info paei
2521: where paf.assignment_id = paei.assignment_id
2522: and aei_information1 = p_ppsn_override
2523: and paf.effective_start_date <= l_end_date
2524: and paf.effective_end_date >= l_start_date

Line 2566: l_ppsn_override per_assignment_extra_info.aei_information1%type;

2562: l_this_weeks_at_sec_class pay_run_result_values.result_value%TYPE;
2563: -- end P60 changes to PRSI section
2564:
2565: --6633719
2566: l_ppsn_override per_assignment_extra_info.aei_information1%type;
2567:
2568: cursor csr_ppsn_override(p_asg_id number)
2569: is
2570: select aei_information1 PPSN_OVERRIDE

Line 2571: from per_assignment_extra_info

2567:
2568: cursor csr_ppsn_override(p_asg_id number)
2569: is
2570: select aei_information1 PPSN_OVERRIDE
2571: from per_assignment_extra_info
2572: where assignment_id = p_asg_id
2573: and aei_information_category = 'IE_ASG_OVERRIDE';
2574:
2575: l_child_assignment_action_id pay_assignment_actions.assignment_action_id%type;

Line 7793: per_assignment_extra_info paei --6633719

7789: pay_run_results prr,
7790: pay_element_types_f pet,
7791: pay_input_values_f piv1,
7792: pay_run_result_values rrv1,
7793: per_assignment_extra_info paei --6633719
7794: WHERE per.person_id = p_person_id
7795: --6633719 these condition added to fetch the contexes having similar PPSN OVERRIDE if given
7796: AND paei.assignment_id(+) = asg.assignment_id
7797: AND paei.aei_information_category(+) = 'IE_ASG_OVERRIDE'

Line 8025: per_assignment_extra_info paei

8021: pay_run_results prr,
8022: pay_element_types_f pet,
8023: pay_input_values_f piv1,
8024: pay_run_result_values rrv1,
8025: per_assignment_extra_info paei
8026: WHERE per.person_id = p_person_id
8027: AND paei.assignment_id(+) = asg.assignment_id
8028: AND paei.aei_information_category(+) = 'IE_ASG_OVERRIDE'
8029: AND nvl(paei.aei_information1,'X') = nvl(p_ppsn_override,'X')