APPS.JAI_AP_TDS_PROCESSING_PKG dependencies on JAI_CMN_TAXES_ALL

Line 205: JAI_CMN_TAXES_ALL jitc

201: ap_checks_all aca ,
202: ap_invoice_payments_all aipa ,
203: ap_invoices_all aia ,
204: jai_ap_tds_thhold_trxs jattt,
205: JAI_CMN_TAXES_ALL jitc
206: where
207: aca.check_id = aipa.check_id
208: and aipa.invoice_id = jattt.invoice_to_tds_authority_id
209: and aipa.invoice_id = aia.invoice_id

Line 240: select tax_id from JAI_CMN_TAXES_ALL where tax_type = 'TDS'

236: and vendor_id = jattt.vendor_id /*Added by nprashar for bug # 6195566*/
237: and invoice_id = aipa.invoice_id /*Added by nprashar for bug # 6195566*/
238: and tds_tax_id in /*bduvarag for Bug#5647725*/
239: (
240: select tax_id from JAI_CMN_TAXES_ALL where tax_type = 'TDS'
241: and section_type = p_section_type)
242: )
243: ;
244:

Line 461: JAI_CMN_TAXES_ALL jatc

457: jatt.vendor_id,
458: jatt.vendor_site_id
459: from
460: jai_ap_tds_thhold_trxs jatt,
461: JAI_CMN_TAXES_ALL jatc
462: where
463: jatt.invoice_to_tds_authority_id = pn_invoice_to_tds_authority_id
464: and jatc.tax_id = jatt.tax_id
465: and jatc.section_type = p_section_type /*bduvarag for Bug#5647725*/ ;

Line 576: JAI_CMN_TAXES_ALL jitc

572: ap_checks_all aca ,
573: ap_invoice_payments_all aipa ,
574: ap_invoices_all aia ,
575: jai_ap_tds_thhold_trxs jattt,
576: JAI_CMN_TAXES_ALL jitc
577: where
578: aca.check_id = aipa.check_id
579: and aipa.invoice_id = jattt.invoice_to_tds_authority_id
580: and aipa.invoice_id = aia.invoice_id

Line 1239: FROM JAI_CMN_TAXES_ALL

1235: and vendor_id = nvl(pn_vendor_id, vendor_id)
1236: and vendor_site_id = nvl(pn_vendor_site_id, vendor_site_id)
1237: and org_tan_num = pv_org_tan_num
1238: and tds_tax_id in ( SELECT tax_id
1239: FROM JAI_CMN_TAXES_ALL
1240: WHERE section_type = p_section_type
1241: );/*bduvarag for Bug#5647725*/
1242:
1243:

Line 1272: FROM JAI_CMN_TAXES_ALL

1268: and vendor_site_id = nvl(pn_vendor_site_id, vendor_site_id)
1269: and org_tan_num = pv_org_tan_num
1270: and operating_unit_id = pn_operating_unit_id
1271: and tds_tax_id in ( SELECT tax_id
1272: FROM JAI_CMN_TAXES_ALL
1273: WHERE section_type = p_section_type
1274: );/*bduvarag for Bug#5647725*/
1275: --Commented below by Bgowrava for Bug#6129650
1276: /*

Line 1324: FROM JAI_CMN_TAXES_ALL

1320: and vendor_id = nvl(pn_vendor_id, vendor_id)
1321: and vendor_site_id = nvl(pn_vendor_site_id, vendor_site_id)
1322: and org_tan_num = pv_org_tan_num
1323: and tds_tax_id in ( SELECT tax_id
1324: FROM JAI_CMN_TAXES_ALL
1325: WHERE section_type = p_section_type
1326: )
1327: group by
1328: fin_year,

Line 1374: FROM JAI_CMN_TAXES_ALL

1370: and vendor_id = nvl(pn_vendor_id, vendor_id)
1371: and vendor_site_id = nvl(pn_vendor_site_id, vendor_site_id)
1372: and org_tan_num = pv_org_tan_num
1373: and tds_tax_id in ( SELECT tax_id
1374: FROM JAI_CMN_TAXES_ALL
1375: WHERE section_type = p_section_type
1376: );/*bduvarag for Bug#5647725*/
1377:
1378:

Line 1562: FROM JAI_CMN_TAXES_ALL

1558: and org_tan_num = pv_org_tan_num
1559: and operating_unit_id = cur_ou.operating_unit_id
1560: and invoice_date = cur_invoice_date.invoice_date
1561: and tds_tax_id in ( SELECT tax_id
1562: FROM JAI_CMN_TAXES_ALL
1563: WHERE section_type = p_section_type
1564: );/*bduvarag for Bug#5647725*/
1565:
1566:

Line 1614: FROM JAI_CMN_TAXES_ALL

1610: and vendor_site_id = cur_rec.vendor_site_id
1611: and org_tan_num = pv_org_tan_num
1612: and operating_unit_id = cur_rec.operating_unit_id
1613: and tds_tax_id in ( SELECT tax_id
1614: FROM JAI_CMN_TAXES_ALL
1615: WHERE section_type = p_section_type
1616: );
1617:
1618: END LOOP; /*c_group_for_no_certificate*/

Line 1672: FROM JAI_CMN_TAXES_ALL

1668: and vendor_site_id = cur_rec.vendor_site_id
1669: and org_tan_num = pv_org_tan_num
1670: and operating_unit_id = cur_rec.operating_unit_id
1671: and tds_tax_id in ( SELECT tax_id
1672: FROM JAI_CMN_TAXES_ALL
1673: WHERE section_type = p_section_type
1674: );/*bduvarag for Bug#5647725*/
1675:
1676: if sql%rowcount = 0 then