DBA Data[Home] [Help]

APPS.JA_JAINOTDS_XMLP_PKG dependencies on JAI_AP_TDS_INVOICES

Line 88: JAI_AP_TDS_INVOICES

84: SELECT
85: TDS_SECTION
86: INTO V_TDS_SECTION
87: FROM
88: JAI_AP_TDS_INVOICES
89: WHERE INVOICE_ID = CF_TDS_SECTIONFORMULA.INVOICE_ID
90: AND TDS_INVOICE_NUM = INVOICE_NUM1;
91: RETURN (V_TDS_SECTION);
92: END IF;

Line 111: JAI_AP_TDS_INVOICES

107: SELECT
108: TDS_TAX_RATE
109: INTO V_TDS_RATE
110: FROM
111: JAI_AP_TDS_INVOICES
112: WHERE INVOICE_ID = CF_TDS_TAX_RATEFORMULA.INVOICE_ID
113: AND TDS_INVOICE_NUM = INVOICE_NUM1;
114: RETURN (V_TDS_RATE);
115: END IF;

Line 135: JAI_AP_TDS_INVOICES

131: SELECT
132: TDS_TAX_ID
133: INTO V_TDS_TAX_ID
134: FROM
135: JAI_AP_TDS_INVOICES
136: WHERE INVOICE_ID = CF_TAX_NAMEFORMULA.INVOICE_ID
137: AND TDS_INVOICE_NUM = INVOICE_NUM1;
138: SELECT
139: TAX_NAME