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.ASO_VALIDATE_PVT dependencies on JTF_RS_SRP_VL

Line 1165: FROM jtf_rs_srp_vl

1161: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1162: IS
1163: CURSOR C_employperson IS
1164: SELECT start_date_active, end_date_active,status
1165: FROM jtf_rs_srp_vl
1166: WHERE person_id = p_employee_id;
1167:
1168: l_start_date DATE;
1169: l_end_date DATE;

Line 1355: /* from jtf_rs_srp_vl */ --Commented Code Yogeshwar (MOAC)

1351: IS
1352:
1353: CURSOR C_sales_rep (l_resource_id NUMBER) IS
1354: select 'VALID'
1355: /* from jtf_rs_srp_vl */ --Commented Code Yogeshwar (MOAC)
1356: from jtf_rs_salesreps_mo_v --New Code Yogeshwar (MOAC)
1357: WHERE trunc(sysdate) BETWEEN trunc(NVL(start_date_active, sysdate))
1358: AND trunc(NVL(end_date_active, sysdate))
1359: --Commentd Code Start Yogeshwar (MOAC)

Line 1402: from jtf_rs_srp_vl

1398: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1399: IS
1400: CURSOR C_emp_res IS
1401: select person_id
1402: from jtf_rs_srp_vl
1403: where resource_id = p_resource_id
1404: and trunc(sysdate) BETWEEN trunc(NVL(start_date_active, sysdate)) AND
1405: trunc(NVL(end_date_active, sysdate));
1406: