APPS.PAY_IN_24Q_ARCHIVE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 9: ,tax_rate per_assignment_extra_info.aei_information2 %TYPE

5: ( person_id per_all_people_f.person_id%TYPE
6: ,pan_number per_all_people_f.per_information14%TYPE
7: ,pan_ref_number per_all_people_f.per_information14%TYPE
8: ,full_name per_all_people_f.full_name%TYPE
9: ,tax_rate per_assignment_extra_info.aei_information2 %TYPE
10: ,position per_all_positions.name%TYPE);
11:
12: TYPE t_person_data_tab_type IS TABLE OF t_person_data_rec
13: INDEX BY binary_integer;

Line 936: FROM per_assignment_extra_info paei

932:
933: CURSOR c_aei_tax_rate(p_person_id NUMBER)
934: IS
935: SELECT paei.aei_information2
936: FROM per_assignment_extra_info paei
937: ,per_assignments_f paa
938: WHERE paei.information_type = 'PER_IN_TAX_EXEMPTION_DF'
939: AND paei.aei_information_category = 'PER_IN_TAX_EXEMPTION_DF'
940: AND paei.assignment_id = paa.assignment_id

Line 958: l_tax_rate per_assignment_extra_info.aei_information2%TYPE;

954: l_pan per_all_people_f.per_information4%TYPE;
955: l_pan_ref_num per_all_people_f.per_information14%TYPE;
956: l_name per_all_people_f.full_name%TYPE;
957: l_pos per_all_positions.name%TYPE;
958: l_tax_rate per_assignment_extra_info.aei_information2%TYPE;
959: l_action_info_id NUMBER;
960: l_ovn NUMBER;
961: flag BOOLEAN;
962: l_full_name per_all_people_f.full_name%TYPE;

Line 2219: FROM per_assignment_extra_info paei

2215:
2216: CURSOR c_aei_tax_rate(p_person_id NUMBER)
2217: IS
2218: SELECT paei.aei_information2
2219: FROM per_assignment_extra_info paei
2220: ,per_assignments_f paa
2221: WHERE paei.information_type = 'PER_IN_TAX_EXEMPTION_DF'
2222: AND paei.aei_information_category = 'PER_IN_TAX_EXEMPTION_DF'
2223: AND paei.assignment_id = paa.assignment_id

Line 2273: l_tax_rate per_assignment_extra_info.aei_information2 %TYPE;

2269: l_full_name per_all_people_f.full_name%TYPE;
2270:
2271: l_pan per_all_people_f.per_information14%TYPE;
2272: l_pan_ref_num per_all_people_f.per_information14%TYPE;
2273: l_tax_rate per_assignment_extra_info.aei_information2 %TYPE;
2274: l_pos per_all_positions.name%TYPE;
2275: l_proc VARCHAR2(100);
2276: l_message VARCHAR2(255);
2277: