eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_TAX_UTILS dependencies on PER_PREVIOUS_EMPLOYERS

Line 1586: from per_previous_employers ppm,

1582: fnd_number.canonical_to_number(nvl(ppm.pem_information23,0)), -- Sec and HE Cess
1583: fnd_number.canonical_to_number(nvl(ppm.pem_information24,0)), -- Exemption under 80ccd
1584: fnd_number.canonical_to_number(nvl(ppm.pem_information25,0)), -- CGHS Exemption under 80D
1585: ppm.end_date
1586: from per_previous_employers ppm,
1587: per_all_assignments_f paa
1588: where paa.assignment_id = p_assignment_id
1589: and paa.person_id = ppm.person_id
1590: and p_date_earned between paa.effective_start_date and paa.effective_end_date;

Line 2625: FROM per_previous_employers ppm,

2621: ,p_end_date date
2622: ,p_assignment_id NUMBER)
2623: IS
2624: SELECT sum(nvl(ppm.pem_information8,0))
2625: FROM per_previous_employers ppm,
2626: per_all_assignments_f paa
2627: WHERE paa.assignment_id = p_assignment_id
2628: AND p_date_earned BETWEEN paa.effective_start_date AND paa.effective_end_date
2629: AND paa.person_id =ppm.person_id

Line 4515: FROM per_previous_employers ppm,

4511:
4512: CURSOR c_prev_emp_details is
4513: SELECT NVL(ppm.pem_information22,0), -- Medical Reimbursement
4514: ppm.end_date
4515: FROM per_previous_employers ppm,
4516: per_all_assignments_f paa
4517: WHERE paa.assignment_id = p_assignment_id
4518: AND paa.person_id = ppm.person_id
4519: AND p_date_earned BETWEEN paa.effective_start_date AND paa.effective_end_date;