[Home] [Help]
236: NULL;
237: END CP_1FORMULA;
238:
239: FUNCTION CF_VEN_PAN_NOFORMULA(VEN_ID IN NUMBER) RETURN CHAR IS
240: V_PAN_NO JAI_AP_TDS_VENDOR_HDRS.PAN_NO%TYPE;
241: CURSOR GET_PAN_NO_CUR(P_VEN_ID IN NUMBER) IS
242: SELECT
243: PAN_NO
244: FROM
241: CURSOR GET_PAN_NO_CUR(P_VEN_ID IN NUMBER) IS
242: SELECT
243: PAN_NO
244: FROM
245: JAI_AP_TDS_VENDOR_HDRS
246: WHERE VENDOR_ID = P_VEN_ID;
247: BEGIN
248: OPEN GET_PAN_NO_CUR(VEN_ID);
249: FETCH GET_PAN_NO_CUR