APPS.OZF_CLAIM_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 5323: FROM jtf_rs_resource_extns

5319: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
5320:
5321: CURSOR resource_id_csr(p_user_id in number) is
5322: SELECT resource_id
5323: FROM jtf_rs_resource_extns
5324: WHERE user_id = p_user_id
5325: AND category = 'EMPLOYEE';
5326:
5327: l_resource_id number;

Line 6782: jtf_rs_resource_extns r,

6778:
6779: CURSOR sales_rep_num_csr (p_id in NUMBER) IS
6780: SELECT count(salesrep_id)
6781: FROM jtf_rs_salesreps s,
6782: jtf_rs_resource_extns r,
6783: fnd_lookups l
6784: WHERE s.start_date_active <= SYSDATE
6785: AND NVL(s.end_date_active, SYSDATE) >= SYSDATE
6786: AND s.salesrep_id = p_id