APPS.CSC_CUST_PLANS_PVT dependencies on CSC_LOOKUPS

Line 1708: from csc_lookups

1704: )
1705: IS
1706: cursor group_in_lookup is
1707: select count(*)
1708: from csc_lookups
1709: where lookup_type = 'CSC_PLAN_STATUS'
1710: and lookup_code = p_PLAN_STATUS_CODE
1711: and sysdate between nvl(start_date_active, sysdate)
1712: and nvl(end_date_active, sysdate);