DBA Data[Home] [Help]

APPS.ASO_SECURITY_INT dependencies on JTF_RS_GROUP_USAGES

Line 32: JTF_RS_GROUP_USAGES UGS,

28: CURSOR C_manager_access (l_resource_id NUMBER, l_quote_number NUMBER) IS
29: SELECT ACC.ACCESS_ID,
30: ACC.UPDATE_ACCESS_FLAG
31: FROM JTF_RS_REP_MANAGERS MGR,
32: JTF_RS_GROUP_USAGES UGS,
33: ASO_QUOTE_ACCESSES ACC
34: WHERE UGS.USAGE = 'SALES'
35: AND UGS.GROUP_ID = MGR.GROUP_ID
36: AND MGR.HIERARCHY_TYPE IN ('MGR_TO_MGR', 'MGR_TO_REP')