APPS.PAY_MX_TAX_FUNCTIONS dependencies on PER_ALL_PEOPLE_F

Line 1021: ln_person_id per_all_people_f.person_id%TYPE;

1017: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
1018: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
1019: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1020: ln_assignment_id pay_assignment_actions.assignment_id%TYPE;
1021: ln_person_id per_all_people_f.person_id%TYPE;
1022: l_classification_id NUMBER;
1023: l_hire_date DATE;
1024: l_exempt_amount NUMBER;
1025: l_counter NUMBER;

Line 2066: ld_hire_date will be wrong when the per_all_people_f table has

2062:
2063: /*bug#8932102:
2064: 1. Seperated ld_hire_date from cursor csr_get_payroll_id
2065: and created seperate cursor to fetch ld_hire_date, this is because
2066: ld_hire_date will be wrong when the per_all_people_f table has
2067: multiple date effective entries
2068: 2. Table reference per_assignments_f has been changed to per_assignments in
2069: cursor csr_get_payroll_id to get latest payroll_id for the assignment*/
2070:

Line 2287: ld_hire_date will be wrong when the per_all_people_f table has

2283:
2284: /*bug#8932102:
2285: 1. Seperated ld_hire_date from cursor csr_get_payroll_id
2286: and created seperate cursor to fetch ld_hire_date, this is because
2287: ld_hire_date will be wrong when the per_all_people_f table has
2288: multiple date effective entries
2289: 2. Table reference per_assignments_f has been changed to per_assignments in
2290: cursor csr_get_payroll_id*/
2291:

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

4114: FROM per_all_assignments_f
4115: WHERE assignment_id=P_CTX_ASSIGNMENT_ID
4116: AND P_CTX_DATE_EARNED BETWEEN effective_start_date AND effective_end_date;
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

Line 4128: l_person_id per_all_people_f.person_id%TYPE;

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