DBA Data[Home] [Help]

APPS.OE_VALIDATE dependencies on JTF_RS_RESOURCE_EXTNS

Line 6002: jtf_rs_resource_extns b

5998:
5999: cursor c_jtf_salesrep(p_salesrep_id IN number) is
6000: select /* MOAC_SQL_CHANGE */ 'VALID'
6001: from jtf_rs_salesreps jrs,
6002: jtf_rs_resource_extns b
6003: where jrs.salesrep_id = p_salesrep_id
6004: and jrs.resource_id = b.resource_id
6005: and b.category in ('EMPLOYEE','OTHER','PARTY','PARTNER','SUPPLIER_CONTACT')
6006: and jrs.org_id =l_org_id