APPS.OZF_CLAIM_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 6213: FROM jtf_rs_resource_extns

6209: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
6210:
6211: CURSOR resource_id_csr(p_user_id in number) is
6212: SELECT resource_id
6213: FROM jtf_rs_resource_extns
6214: WHERE user_id = p_user_id
6215: AND category = 'EMPLOYEE';
6216:
6217: l_resource_id number;

Line 8435: jtf_rs_resource_extns r,

8431:
8432: CURSOR sales_rep_num_csr (p_id in NUMBER) IS
8433: SELECT count(salesrep_id)
8434: FROM jtf_rs_salesreps s,
8435: jtf_rs_resource_extns r,
8436: fnd_lookups l
8437: WHERE s.start_date_active <= SYSDATE
8438: AND NVL(s.end_date_active, SYSDATE) >= SYSDATE
8439: AND s.salesrep_id = p_id