DBA Data[Home] [Help]

APPS.AS_OPP_SALES_CREDIT_PVT dependencies on JTF_RS_GROUPS_B

Line 2838: FROM JTF_RS_GROUPS_B a, JTF_RS_GROUP_USAGES b

2834: WHERE SALES_GROUP_ID = c_SALES_GROUP_ID;
2835:
2836: CURSOR C_PRTNR_SALES_GROUP_ID_Exists(c_SALES_GROUP_ID NUMBER) IS
2837: SELECT 'X'
2838: FROM JTF_RS_GROUPS_B a, JTF_RS_GROUP_USAGES b
2839: WHERE a.group_id = b.group_id
2840: AND b.usage in ('SALES','PRM')
2841: AND sysdate between nvl(a.start_date_active,sysdate) and
2842: nvl(a.end_date_active,sysdate)