APPS.PAY_IN_24QC_ARCHIVE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 1187: FROM per_assignment_extra_info paei

1183: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1184: AND (
1185: (
1186: (NVL(pai.action_information13,'0') <> (SELECT NVL(paei.aei_information2,'0')
1187: FROM per_assignment_extra_info paei
1188: ,per_assignments_f paa
1189: WHERE paei.information_type = 'PER_IN_TAX_EXEMPTION_DF'
1190: AND paei.aei_information_category = 'PER_IN_TAX_EXEMPTION_DF'
1191: AND paei.assignment_id = paa.assignment_id

Line 1294: FROM per_assignment_extra_info paei

1290: AND asg.business_group_id = pep.business_group_id
1291: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1292: AND (
1293: (NVL(pai.action_information18,'0') <> (SELECT NVL(paei.aei_information2,'0')
1294: FROM per_assignment_extra_info paei
1295: ,per_assignments_f paa
1296: WHERE paei.information_type = 'PER_IN_TAX_EXEMPTION_DF'
1297: AND paei.aei_information_category = 'PER_IN_TAX_EXEMPTION_DF'
1298: AND paei.assignment_id = paa.assignment_id

Line 1351: FROM per_assignment_extra_info paei

1347: AND asg.business_group_id = pep.business_group_id
1348: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1349: AND (
1350: (NVL(pai.action_information18,'0') = (SELECT NVL(paei.aei_information2,'0')
1351: FROM per_assignment_extra_info paei
1352: ,per_assignments_f paa
1353: WHERE paei.information_type = 'PER_IN_TAX_EXEMPTION_DF'
1354: AND paei.aei_information_category = 'PER_IN_TAX_EXEMPTION_DF'
1355: AND paei.assignment_id = paa.assignment_id

Line 4223: FROM per_assignment_extra_info paei

4219:
4220: CURSOR c_aei_tax_rate(p_person_id NUMBER)
4221: IS
4222: SELECT paei.aei_information2
4223: FROM per_assignment_extra_info paei
4224: ,per_assignments_f paa
4225: WHERE paei.information_type = 'PER_IN_TAX_EXEMPTION_DF'
4226: AND paei.aei_information_category = 'PER_IN_TAX_EXEMPTION_DF'
4227: AND paei.assignment_id = paa.assignment_id

Line 4238: l_tax_rate per_assignment_extra_info.aei_information2 %TYPE;

4234: l_person_id per_all_people_f.person_id%TYPE;
4235: l_pan_number per_all_people_f.per_information14%TYPE;
4236: l_pan_ref_number per_all_people_f.per_information14%TYPE;
4237: l_full_name per_all_people_f.full_name%TYPE;
4238: l_tax_rate per_assignment_extra_info.aei_information2 %TYPE;
4239: l_end_date DATE;
4240: l_old_tax_rate per_assignment_extra_info.aei_information2 %TYPE;
4241: l_action_information_id NUMBER;
4242: l_procedure VARCHAR2(250);

Line 4240: l_old_tax_rate per_assignment_extra_info.aei_information2 %TYPE;

4236: l_pan_ref_number per_all_people_f.per_information14%TYPE;
4237: l_full_name per_all_people_f.full_name%TYPE;
4238: l_tax_rate per_assignment_extra_info.aei_information2 %TYPE;
4239: l_end_date DATE;
4240: l_old_tax_rate per_assignment_extra_info.aei_information2 %TYPE;
4241: l_action_information_id NUMBER;
4242: l_procedure VARCHAR2(250);
4243: l_message VARCHAR2(250);
4244: BEGIN