APPS.PAY_IE_P35 dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 79: FROM per_assignment_extra_info

75:
76: CURSOR csr_ppsn_override(p_asg_id NUMBER)
77: IS
78: SELECT aei_information1 PPSN_OVERRIDE
79: FROM per_assignment_extra_info
80: WHERE assignment_id = p_asg_id
81: AND aei_information_category = 'IE_ASG_OVERRIDE';
82:
83: l_ppsn_override varchar2(100);

Line 941: from per_assignment_extra_info

937: --6633719
938: cursor csr_ppsn_override(p_asg_id number)
939: is
940: select aei_information1 PPSN_OVERRIDE
941: from per_assignment_extra_info
942: where assignment_id = p_asg_id
943: and aei_information_category = 'IE_ASG_OVERRIDE';
944:
945: l_ppsn_override per_assignment_extra_info.aei_information1%type;

Line 945: l_ppsn_override per_assignment_extra_info.aei_information1%type;

941: from per_assignment_extra_info
942: where assignment_id = p_asg_id
943: and aei_information_category = 'IE_ASG_OVERRIDE';
944:
945: l_ppsn_override per_assignment_extra_info.aei_information1%type;
946:
947: cursor csr_ppsn_max_asg(p_ppsn_override varchar2, p_person_id number)
948: is
949: select MAX(paei.assignment_id) ovrride_asg

Line 950: from per_assignment_extra_info paei

946:
947: cursor csr_ppsn_max_asg(p_ppsn_override varchar2, p_person_id number)
948: is
949: select MAX(paei.assignment_id) ovrride_asg
950: from per_assignment_extra_info paei
951: where paei.information_type = 'IE_ASG_OVERRIDE'
952: and paei.aei_information1 = p_ppsn_override
953: and exists
954: (select 1 from per_all_assignments_f paaf

Line 959: l_ppsn_override_asg per_assignment_extra_info.assignment_id%type;

955: where paaf.assignment_id = paei.assignment_id
956: and paaf.person_id = p_person_id)
957: GROUP BY paei.aei_information1;
958:
959: l_ppsn_override_asg per_assignment_extra_info.assignment_id%type;
960:
961: --6633719
962:
963: -- Dont create action if the latest tax basis is exclusion 5867343

Line 2062: from per_assignments_f paf, per_assignment_extra_info paei

2058: --6633719
2059: /* Cursor to fetch primary flag for terminated assignments for PPSN OVERRIDE case*/
2060: CURSOR csr_get_primary_flag1(p_ppsn_override varchar2) is
2061: select NVL (SUBSTR (paf.assignment_number, 1, 12), ' ') -- WORKS NUMBER
2062: from per_assignments_f paf, per_assignment_extra_info paei
2063: where paf.assignment_id = paei.assignment_id
2064: and aei_information1 = p_ppsn_override
2065: and paf.effective_start_date <= l_end_date
2066: and paf.effective_end_date >= l_start_date

Line 2074: per_assignment_extra_info paei

2070: /* Cursor to fetch primary flag for active assignments PPSN OVERRIDE case*/
2071: CURSOR csr_get_primary_flag_active1(p_ppsn_override varchar2) is
2072: select NVL (SUBSTR (paf.assignment_number, 1, 12), ' ') -- WORKS NUMBER
2073: from per_assignments_f paf,
2074: per_assignment_extra_info paei
2075: where paf.assignment_id = paei.assignment_id
2076: and aei_information1 = p_ppsn_override
2077: and paf.effective_start_date <= l_end_date
2078: and paf.effective_end_date >= l_start_date

Line 2117: l_ppsn_override per_assignment_extra_info.aei_information1%type;

2113: l_this_weeks_at_sec_class pay_run_result_values.result_value%TYPE;
2114: -- end P60 changes to PRSI section
2115:
2116: --6633719
2117: l_ppsn_override per_assignment_extra_info.aei_information1%type;
2118:
2119: cursor csr_ppsn_override(p_asg_id number)
2120: is
2121: select aei_information1 PPSN_OVERRIDE

Line 2122: from per_assignment_extra_info

2118:
2119: cursor csr_ppsn_override(p_asg_id number)
2120: is
2121: select aei_information1 PPSN_OVERRIDE
2122: from per_assignment_extra_info
2123: where assignment_id = p_asg_id
2124: and aei_information_category = 'IE_ASG_OVERRIDE';
2125:
2126: l_child_assignment_action_id pay_assignment_actions.assignment_action_id%type;

Line 4728: per_assignment_extra_info paei --6633719

4724: pay_run_results prr,
4725: pay_element_types_f pet,
4726: pay_input_values_f piv1,
4727: pay_run_result_values rrv1,
4728: per_assignment_extra_info paei --6633719
4729: WHERE per.person_id = p_person_id
4730: --6633719 these condition added to fetch the contexes having similar PPSN OVERRIDE if given
4731: AND paei.assignment_id(+) = asg.assignment_id
4732: AND paei.aei_information_category(+) = 'IE_ASG_OVERRIDE'