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)
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: