APPS.PAY_IN_24QC_ARCHIVE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 1080: FROM per_assignment_extra_info paei

1076: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1077: AND (
1078: (
1079: (NVL(pai.action_information13,'0') <> (SELECT NVL(paei.aei_information2,'0')
1080: FROM per_assignment_extra_info paei
1081: ,per_assignments_f paa
1082: WHERE paei.information_type = 'PER_IN_TAX_EXEMPTION_DF'
1083: AND paei.aei_information_category = 'PER_IN_TAX_EXEMPTION_DF'
1084: AND paei.assignment_id = paa.assignment_id

Line 1187: FROM per_assignment_extra_info paei

1183: AND asg.business_group_id = pep.business_group_id
1184: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1185: AND (
1186: (NVL(pai.action_information18,'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 1244: FROM per_assignment_extra_info paei

1240: AND asg.business_group_id = pep.business_group_id
1241: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1242: AND (
1243: (NVL(pai.action_information18,'0') = (SELECT NVL(paei.aei_information2,'0')
1244: FROM per_assignment_extra_info paei
1245: ,per_assignments_f paa
1246: WHERE paei.information_type = 'PER_IN_TAX_EXEMPTION_DF'
1247: AND paei.aei_information_category = 'PER_IN_TAX_EXEMPTION_DF'
1248: AND paei.assignment_id = paa.assignment_id

Line 3899: FROM per_assignment_extra_info paei

3895:
3896: CURSOR c_aei_tax_rate(p_person_id NUMBER)
3897: IS
3898: SELECT paei.aei_information2
3899: FROM per_assignment_extra_info paei
3900: ,per_assignments_f paa
3901: WHERE paei.information_type = 'PER_IN_TAX_EXEMPTION_DF'
3902: AND paei.aei_information_category = 'PER_IN_TAX_EXEMPTION_DF'
3903: AND paei.assignment_id = paa.assignment_id

Line 3914: l_tax_rate per_assignment_extra_info.aei_information2 %TYPE;

3910: l_person_id per_all_people_f.person_id%TYPE;
3911: l_pan_number per_all_people_f.per_information14%TYPE;
3912: l_pan_ref_number per_all_people_f.per_information14%TYPE;
3913: l_full_name per_all_people_f.full_name%TYPE;
3914: l_tax_rate per_assignment_extra_info.aei_information2 %TYPE;
3915: l_end_date DATE;
3916: l_old_tax_rate per_assignment_extra_info.aei_information2 %TYPE;
3917: l_action_information_id NUMBER;
3918: l_procedure VARCHAR2(250);

Line 3916: l_old_tax_rate per_assignment_extra_info.aei_information2 %TYPE;

3912: l_pan_ref_number per_all_people_f.per_information14%TYPE;
3913: l_full_name per_all_people_f.full_name%TYPE;
3914: l_tax_rate per_assignment_extra_info.aei_information2 %TYPE;
3915: l_end_date DATE;
3916: l_old_tax_rate per_assignment_extra_info.aei_information2 %TYPE;
3917: l_action_information_id NUMBER;
3918: l_procedure VARCHAR2(250);
3919: l_message VARCHAR2(250);
3920: BEGIN