APPS.PAY_MX_TAX_FUNCTIONS dependencies on PER_PEOPLE_EXTRA_INFO

Line 2823: FROM per_people_extra_info

2819:
2820: CURSOR get_exempt_adjustment(p_person_id per_all_people_f.person_id%TYPE)
2821: IS
2822: SELECT pei_information1
2823: FROM per_people_extra_info
2824: WHERE person_id = p_person_id
2825: AND information_type='MX_EMP_TAX_SIGNUP'
2826: AND P_CTX_DATE_EARNED BETWEEN fnd_date.canonical_to_date(pei_information2)
2827: AND fnd_date.canonical_to_date(pei_information3);

Line 2831: l_exempt_adj per_people_extra_info.pei_information1%TYPE;

2827: AND fnd_date.canonical_to_date(pei_information3);
2828:
2829: l_flag VARCHAR2(4);
2830: l_person_id per_all_people_f.person_id%TYPE;
2831: l_exempt_adj per_people_extra_info.pei_information1%TYPE;
2832:
2833: BEGIN
2834:
2835: l_flag:='N';