DBA Data[Home] [Help]

APPS.OKL_SUC_PVT dependencies on RA_TERRITORIES

Line 611: From ra_territories RAT

607: --p_sales_territory_code IN VARCHAR2) IS
608: --Bug# 3508166 :
609: Cursor terr_csr(p_sales_territory_id in number) is
610: Select 'Y'
611: From ra_territories RAT
612: where RAT.territory_id = p_sales_territory_id
613: and RAT.enabled_flag = 'Y'
614: and nvl(RAT.status,'I') = 'A'
615: and sysdate between nvl(RAT.start_date_active,sysdate) and nvl(RAT.end_date_active,sysdate);