APPS.OKS_EXTWAR_UTIL_PUB dependencies on JTF_RS_SALESREPS

Line 396: From jtf_rs_salesreps

392:
393: FUNCTION GET_SALESREP_ID (p_resource_id Number,p_org_id Number ) RETURN NUMBER IS
394: Cursor l_salesrep_csr IS
395: SELECT salesrep_id
396: From jtf_rs_salesreps
397: Where resource_id = p_resource_id and org_id = p_org_id;
398: l_salesrep_id NUMBER;
399: BEGIN
400: FOR c_l_salesrep_csr in l_salesrep_csr LOOP

Line 980: From jtf_rs_salesreps a,

976:
977: FUNCTION GET_CHR_SALESREP_ID (p_resource_id Number,p_chr_id Number ) RETURN NUMBER IS
978: Cursor l_salesrep_csr IS
979: SELECT a.salesrep_id
980: From jtf_rs_salesreps a,
981: okc_k_headers_b b
982: Where b.id = p_chr_id
983: and a.resource_id = p_resource_id
984: and a.org_id = b.authoring_org_id;