APPS.PAY_MX_TAX_FUNCTIONS dependencies on PER_PEOPLE_EXTRA_INFO

Line 4121: FROM per_people_extra_info

4117:
4118: CURSOR get_exempt_adjustment(p_person_id per_all_people_f.person_id%TYPE)
4119: IS
4120: SELECT pei_information1
4121: FROM per_people_extra_info
4122: WHERE person_id = p_person_id
4123: AND information_type='MX_EMP_TAX_SIGNUP'
4124: AND P_CTX_DATE_EARNED BETWEEN fnd_date.canonical_to_date(pei_information2)
4125: AND fnd_date.canonical_to_date(pei_information3);

Line 4129: l_exempt_adj per_people_extra_info.pei_information1%TYPE;

4125: AND fnd_date.canonical_to_date(pei_information3);
4126:
4127: l_flag VARCHAR2(4);
4128: l_person_id per_all_people_f.person_id%TYPE;
4129: l_exempt_adj per_people_extra_info.pei_information1%TYPE;
4130:
4131: BEGIN
4132:
4133: l_flag:='N';