APPS.OKS_OKSSCOFM_XMLP_PKG dependencies on JTF_RS_SALESREPS

Line 32: P_SALESREP_NAME JTF_RS_SALESREPS.NAME%TYPE;

28: END IF;
29: END CF_FORECAST_REVFORMULA;
30: FUNCTION CF_SALESREP_NAMEFORMULA(SR_SALESREP_ID IN VARCHAR2
31: ,ORG_ID IN NUMBER) RETURN CHAR IS
32: P_SALESREP_NAME JTF_RS_SALESREPS.NAME%TYPE;
33: BEGIN
34: SELECT
35: NAME
36: INTO P_SALESREP_NAME

Line 38: JTF_RS_SALESREPS

34: SELECT
35: NAME
36: INTO P_SALESREP_NAME
37: FROM
38: JTF_RS_SALESREPS
39: WHERE SALESREP_ID = SR_SALESREP_ID
40: AND ORG_ID = CF_SALESREP_NAMEFORMULA.ORG_ID
41: AND ROWNUM < 2;
42: RETURN (P_SALESREP_NAME);

Line 148: JTF_RS_SALESREPS

144: CURSOR C1(CN_SALESREPID IN NUMBER,CN_ORGID IN NUMBER) IS
145: SELECT
146: NAME
147: FROM
148: JTF_RS_SALESREPS
149: WHERE SALESREP_ID = CN_SALESREPID;
150: CURSOR C2(CN_ORG_ID IN NUMBER) IS
151: SELECT
152: NAME