APPS.OKL_SUC_PVT dependencies on AR_LOOKUPS

Line 716: From ar_lookups arlk

712: x_return_status OUT NOCOPY VARCHAR2,
713: p_credit_classification_code IN VARCHAR2) IS
714: Cursor crdt_class_csr(p_credit_classification_code in varchar2) is
715: Select 'Y'
716: From ar_lookups arlk
717: where arlk.lookup_type = 'AR_CMGT_TRADE_RATINGS'
718: and arlk.lookup_code = p_credit_classification_code
719: and nvl(arlk.enabled_flag,'N') = 'Y'
720: and sysdate between nvl(arlk.start_date_active,sysdate)

Line 766: From ar_lookups arlk

762: p_industry_code_type IN VARCHAR2) IS
763:
764: Cursor sic_type_csr(p_industry_code_type in varchar2) is
765: Select 'Y'
766: From ar_lookups arlk
767: where arlk.lookup_type = 'SIC_CODE_TYPE'
768: and arlk.lookup_code = p_industry_code_type
769: and nvl(arlk.enabled_flag,'N') = 'Y'
770: and sysdate between nvl(arlk.start_date_active,sysdate)

Line 992: from ar_lookups

988: --cursor to validate foreign key for Industry code
989: cursor l_sic_code_csr (p_industry_code_type in varchar2,
990: p_industry_code in varchar2) is
991: select 'Y'
992: from ar_lookups
993: where lookup_type = p_industry_code_type
994: and lookup_code = p_industry_code
995: and nvl(enabled_flag,'N') = 'Y'
996: and sysdate between nvl(start_date_active,sysdate)