APPS.JA_JAINITCP_XMLP_PKG dependencies on JAI_AP_TDS_VENDOR_HDRS

Line 152: JAI_AP_TDS_VENDOR_HDRS TDS

148: ,'NULL') )
149: FROM
150: PO_VENDORS PO,
151: JAI_AP_TDS_F16_HDRS_ALL AFRM,
152: JAI_AP_TDS_VENDOR_HDRS TDS
153: WHERE PO.VENDOR_ID = AFRM.TAX_AUTHORITY_ID
154: AND TDS.TAX_ID = AFRM.TDS_TAX_ID
155: AND AFRM.TDS_TAX_SECTION = P_TDS_PAYMENT_TYPE;
156: CURSOR ATTRIBUTE14_CUR(CP_ORGANIZATION_ID IN NUMBER) IS

Line 367: FUNCTION GET_PAN_TAN(P_VENDOR_ID IN JAI_AP_TDS_VENDOR_HDRS.VENDOR_ID%TYPE

363: ,VENDOR_SITE_ID
364: ,'PAN');
365: END CF_PAN_NOFORMULA;
366:
367: FUNCTION GET_PAN_TAN(P_VENDOR_ID IN JAI_AP_TDS_VENDOR_HDRS.VENDOR_ID%TYPE
368: ,P_VENDOR_SITE_ID IN JAI_AP_TDS_VENDOR_HDRS.VENDOR_SITE_ID%TYPE
369: ,P_PAN_OR_TAN IN VARCHAR2) RETURN VARCHAR2 IS
370: CURSOR CUR_PAN_TAN(CP_VENDOR_ID IN JAI_AP_TDS_VENDOR_HDRS.VENDOR_ID%TYPE,CP_VENDOR_SITE_ID IN JAI_AP_TDS_VENDOR_HDRS.VENDOR_SITE_ID%TYPE) IS
371: SELECT

Line 368: ,P_VENDOR_SITE_ID IN JAI_AP_TDS_VENDOR_HDRS.VENDOR_SITE_ID%TYPE

364: ,'PAN');
365: END CF_PAN_NOFORMULA;
366:
367: FUNCTION GET_PAN_TAN(P_VENDOR_ID IN JAI_AP_TDS_VENDOR_HDRS.VENDOR_ID%TYPE
368: ,P_VENDOR_SITE_ID IN JAI_AP_TDS_VENDOR_HDRS.VENDOR_SITE_ID%TYPE
369: ,P_PAN_OR_TAN IN VARCHAR2) RETURN VARCHAR2 IS
370: CURSOR CUR_PAN_TAN(CP_VENDOR_ID IN JAI_AP_TDS_VENDOR_HDRS.VENDOR_ID%TYPE,CP_VENDOR_SITE_ID IN JAI_AP_TDS_VENDOR_HDRS.VENDOR_SITE_ID%TYPE) IS
371: SELECT
372: PAN_NO,

Line 370: CURSOR CUR_PAN_TAN(CP_VENDOR_ID IN JAI_AP_TDS_VENDOR_HDRS.VENDOR_ID%TYPE,CP_VENDOR_SITE_ID IN JAI_AP_TDS_VENDOR_HDRS.VENDOR_SITE_ID%TYPE) IS

366:
367: FUNCTION GET_PAN_TAN(P_VENDOR_ID IN JAI_AP_TDS_VENDOR_HDRS.VENDOR_ID%TYPE
368: ,P_VENDOR_SITE_ID IN JAI_AP_TDS_VENDOR_HDRS.VENDOR_SITE_ID%TYPE
369: ,P_PAN_OR_TAN IN VARCHAR2) RETURN VARCHAR2 IS
370: CURSOR CUR_PAN_TAN(CP_VENDOR_ID IN JAI_AP_TDS_VENDOR_HDRS.VENDOR_ID%TYPE,CP_VENDOR_SITE_ID IN JAI_AP_TDS_VENDOR_HDRS.VENDOR_SITE_ID%TYPE) IS
371: SELECT
372: PAN_NO,
373: TAN_NO
374: FROM

Line 375: JAI_AP_TDS_VENDOR_HDRS

371: SELECT
372: PAN_NO,
373: TAN_NO
374: FROM
375: JAI_AP_TDS_VENDOR_HDRS
376: WHERE VENDOR_ID = CP_VENDOR_ID
377: AND VENDOR_SITE_ID = CP_VENDOR_SITE_ID;
378: LR_PAN_TAN CUR_PAN_TAN%ROWTYPE;
379: BEGIN