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 1017: FROM per_assignment_extra_info paei

1013:
1014: CURSOR c_aei_tax_rate(p_person_id NUMBER)
1015: IS
1016: SELECT paei.aei_information2
1017: FROM per_assignment_extra_info paei
1018: ,per_assignments_f paa
1019: WHERE paei.information_type = 'PER_IN_TAX_EXEMPTION_DF'
1020: AND paei.aei_information_category = 'PER_IN_TAX_EXEMPTION_DF'
1021: AND paei.assignment_id = paa.assignment_id

Line 1039: l_tax_rate per_assignment_extra_info.aei_information2%TYPE;

1035: l_pan per_all_people_f.per_information4%TYPE;
1036: l_pan_ref_num per_all_people_f.per_information14%TYPE;
1037: l_name per_all_people_f.full_name%TYPE;
1038: l_pos per_all_positions.name%TYPE;
1039: l_tax_rate per_assignment_extra_info.aei_information2%TYPE;
1040: l_action_info_id NUMBER;
1041: l_ovn NUMBER;
1042: flag BOOLEAN;
1043: l_full_name per_all_people_f.full_name%TYPE;

Line 2325: FROM per_assignment_extra_info paei

2321:
2322: CURSOR c_aei_tax_rate(p_person_id NUMBER)
2323: IS
2324: SELECT paei.aei_information2
2325: FROM per_assignment_extra_info paei
2326: ,per_assignments_f paa
2327: WHERE paei.information_type = 'PER_IN_TAX_EXEMPTION_DF'
2328: AND paei.aei_information_category = 'PER_IN_TAX_EXEMPTION_DF'
2329: AND paei.assignment_id = paa.assignment_id

Line 2379: l_tax_rate per_assignment_extra_info.aei_information2 %TYPE;

2375: l_full_name per_all_people_f.full_name%TYPE;
2376:
2377: l_pan per_all_people_f.per_information14%TYPE;
2378: l_pan_ref_num per_all_people_f.per_information14%TYPE;
2379: l_tax_rate per_assignment_extra_info.aei_information2 %TYPE;
2380: l_pos per_all_positions.name%TYPE;
2381: l_proc VARCHAR2(100);
2382: l_message VARCHAR2(255);
2383: