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_MX_TAX_FUNCTIONS dependencies on PER_ALL_ASSIGNMENTS_F

Line 1961: FROM per_all_assignments_f

1957: WHERE assignment_id = P_ASSIGNMENT_ID;
1958:
1959: CURSOR csr_get_hire_date IS /* bug#8932102 */
1960: SELECT min(effective_start_date)
1961: FROM per_all_assignments_f
1962: WHERE assignment_id = P_ASSIGNMENT_ID
1963: AND assignment_type='E';
1964:
1965: CURSOR csr_def_bal_id (p_balance_name varchar2

Line 2738: FROM per_all_assignments_f

2734: WHERE assignment_id = P_ASSIGNMENT_ID;
2735:
2736: CURSOR csr_get_hire_date IS /* bug#8932102 */
2737: SELECT min(effective_start_date)
2738: FROM per_all_assignments_f
2739: WHERE assignment_id = P_ASSIGNMENT_ID
2740: AND assignment_type='E';
2741:
2742: CURSOR csr_def_bal_id (p_balance_name varchar2

Line 4114: FROM per_all_assignments_f

4110:
4111: CURSOR get_person_id
4112: IS
4113: SELECT person_id
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)