DBA Data[Home] [Help]

APPS.PAY_IN_TAX_UTILS dependencies on PER_PREVIOUS_EMPLOYERS

Line 1229: from per_previous_employers ppm,

1225: fnd_number.canonical_to_number(nvl(ppm.pem_information22,0)), -- Medical Reimbursement
1226: fnd_number.canonical_to_number(nvl(ppm.pem_information23,0)), -- Sec and HE Cess
1227: fnd_number.canonical_to_number(nvl(ppm.pem_information24,0)), -- Exemption under 80ccd
1228: ppm.end_date
1229: from per_previous_employers ppm,
1230: per_all_assignments_f paa
1231: where paa.assignment_id = p_assignment_id
1232: and paa.person_id = ppm.person_id
1233: and p_date_earned between paa.effective_start_date and paa.effective_end_date;

Line 2190: FROM per_previous_employers ppm,

2186: ,p_end_date date
2187: ,p_assignment_id NUMBER)
2188: IS
2189: SELECT sum(nvl(ppm.pem_information8,0))
2190: FROM per_previous_employers ppm,
2191: per_all_assignments_f paa
2192: WHERE paa.assignment_id = p_assignment_id
2193: AND p_date_earned BETWEEN paa.effective_start_date AND paa.effective_end_date
2194: AND paa.person_id =ppm.person_id

Line 3462: FROM per_previous_employers ppm,

3458:
3459: CURSOR c_prev_emp_details is
3460: SELECT NVL(ppm.pem_information22,0), -- Medical Reimbursement
3461: ppm.end_date
3462: FROM per_previous_employers ppm,
3463: per_all_assignments_f paa
3464: WHERE paa.assignment_id = p_assignment_id
3465: AND paa.person_id = ppm.person_id
3466: AND p_date_earned BETWEEN paa.effective_start_date AND paa.effective_end_date;