DBA Data[Home] [Help]

APPS.OKL_PYD_PVT dependencies on PO_LOOKUP_CODES

Line 779: From PO_LOOKUP_CODES

775: p_pay_group IN VARCHAR2) IS
776:
777: CURSOR l_paygroup_csr (p_pay_group in varchar2) IS
778: SELECT 'Y'
779: From PO_LOOKUP_CODES
780: Where lookup_type = 'PAY GROUP'
781: --Bug# 3566580 : 11.5.8 enabled flag is not there in table po_lookup_codes
782: --And nvl(enabled_flag,'N') = 'Y'
783: And sysdate <= nvl(inactive_date,sysdate)

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

777: CURSOR l_paygroup_csr (p_pay_group in varchar2) IS
778: SELECT 'Y'
779: From PO_LOOKUP_CODES
780: Where lookup_type = 'PAY GROUP'
781: --Bug# 3566580 : 11.5.8 enabled flag is not there in table po_lookup_codes
782: --And nvl(enabled_flag,'N') = 'Y'
783: And sysdate <= nvl(inactive_date,sysdate)
784: And lookup_code = p_pay_group;
785: