DBA Data[Home] [Help]

APPS.OKL_PYD_PVT dependencies on PO_LOOKUP_CODES

Line 789: From PO_LOOKUP_CODES

785: p_pay_group IN VARCHAR2) IS
786:
787: CURSOR l_paygroup_csr (p_pay_group in varchar2) IS
788: SELECT 'Y'
789: From PO_LOOKUP_CODES
790: Where lookup_type = 'PAY GROUP'
791: --Bug# 3566580 : 11.5.8 enabled flag is not there in table po_lookup_codes
792: --And nvl(enabled_flag,'N') = 'Y'
793: And sysdate <= nvl(inactive_date,sysdate)

Line 791: --Bug# 3566580 : 11.5.8 enabled flag is not there in table po_lookup_codes

787: CURSOR l_paygroup_csr (p_pay_group in varchar2) IS
788: SELECT 'Y'
789: From PO_LOOKUP_CODES
790: Where lookup_type = 'PAY GROUP'
791: --Bug# 3566580 : 11.5.8 enabled flag is not there in table po_lookup_codes
792: --And nvl(enabled_flag,'N') = 'Y'
793: And sysdate <= nvl(inactive_date,sysdate)
794: And lookup_code = p_pay_group;
795: