APPS.PAY_MX_TAX_FUNCTIONS dependencies on PER_ALL_PEOPLE_F

Line 930: ln_person_id per_all_people_f.person_id%TYPE;

926: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
927: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
928: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
929: ln_assignment_id pay_assignment_actions.assignment_id%TYPE;
930: ln_person_id per_all_people_f.person_id%TYPE;
931: l_classification_id NUMBER;
932: l_hire_date DATE;
933: l_exempt_amount NUMBER;
934: l_counter NUMBER;

Line 2820: CURSOR get_exempt_adjustment(p_person_id per_all_people_f.person_id%TYPE)

2816: FROM per_all_assignments_f
2817: WHERE assignment_id=P_CTX_ASSIGNMENT_ID
2818: AND P_CTX_DATE_EARNED BETWEEN effective_start_date AND effective_end_date;
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

Line 2830: l_person_id per_all_people_f.person_id%TYPE;

2826: AND P_CTX_DATE_EARNED BETWEEN fnd_date.canonical_to_date(pei_information2)
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: