APPS.CN_PROCESS_TAE_TRX_PUB dependencies on JTF_TAE_1001_SC_WINNERS

Line 60: JTF_TAE_1001_SC_WINNERS WIN

56: WIN.org_id,
57: WIN.role,
58: WIN.resource_id
59: FROM
60: JTF_TAE_1001_SC_WINNERS WIN
61:
62: WHERE
63: WIN.SOURCE_ID = -1001 AND
64: WIN.TRANS_OBJECT_TYPE_ID = -1002 AND

Line 69: TYPE role_list is TABLE of JTF_TAE_1001_SC_WINNERS.role%TYPE;

65: WIN.ORG_ID=p_org_id;
66:
67: TYPE api_id_list is TABLE of cn_comm_lines_api.comm_lines_api_id%TYPE;
68: TYPE org_id_list is TABLE of cn_comm_lines_api.org_id%TYPE;
69: TYPE role_list is TABLE of JTF_TAE_1001_SC_WINNERS.role%TYPE;
70: TYPE resource_id_list is TABLE of JTF_TAE_1001_SC_WINNERS.resource_id%TYPE;
71:
72: l_api_id api_id_list;
73: l_org_id org_id_list;

Line 70: TYPE resource_id_list is TABLE of JTF_TAE_1001_SC_WINNERS.resource_id%TYPE;

66:
67: TYPE api_id_list is TABLE of cn_comm_lines_api.comm_lines_api_id%TYPE;
68: TYPE org_id_list is TABLE of cn_comm_lines_api.org_id%TYPE;
69: TYPE role_list is TABLE of JTF_TAE_1001_SC_WINNERS.role%TYPE;
70: TYPE resource_id_list is TABLE of JTF_TAE_1001_SC_WINNERS.resource_id%TYPE;
71:
72: l_api_id api_id_list;
73: l_org_id org_id_list;
74: l_role role_list;

Line 489: JTF_TAE_1001_SC_WINNERS b,

485: ORDER BY b.resource_id), 2) split_trx_amout,
486: ROW_NUMBER() OVER (PARTITION BY a.comm_lines_api_id
487: ORDER BY b.resource_id) rn
488: FROM cn_comm_lines_api a,
489: JTF_TAE_1001_SC_WINNERS b,
490: jtf_rs_roles_vl JR,
491: cn_salesreps CS
492: WHERE a.comm_lines_api_id = b.trans_object_id
493: AND NVL(a.org_id, -777) = NVL(b.org_id, -777)