DBA Data[Home] [Help]

APPS.JAI_AP_TDS_PROCESSING_PKG dependencies on JAI_AP_TDS_ORG_TAN_V

Line 207: from JAI_AP_TDS_ORG_TAN_V

203: )
204: and aca.org_id in
205: (
206: select organization_id org_id
207: from JAI_AP_TDS_ORG_TAN_V
208: where org_tan_num = pv_org_tan_num
209: --Removed the union code by Bgowrava for Bug#6129650
210: )
211: and jattt.tds_authority_vendor_id = nvl(pn_tds_authority_id, jattt.tds_authority_vendor_id)

Line 282: from JAI_AP_TDS_ORG_TAN_V

278: )
279: and aca.org_id in
280: (
281: select organization_id org_id
282: from JAI_AP_TDS_ORG_TAN_V
283: where org_tan_num = pv_org_tan_num
284: --Removed the union code by Bgowrava for Bug#6129650
285: )
286: and not exists (

Line 412: from JAI_AP_TDS_ORG_TAN_V

408: and aia.vendor_site_id = nvl(pn_tds_authority_site_id, aia.vendor_site_id)
409: and aia.org_id in
410: (
411: select organization_id org_id
412: from JAI_AP_TDS_ORG_TAN_V
413: where org_tan_num = pv_org_tan_num
414: --Removed the union code by Bgowrava for Bug#6129650
415: )
416: and not exists (

Line 574: from JAI_AP_TDS_ORG_TAN_V

570: and aca.status_lookup_code NOT IN (lv_sts_lookup_code_argument1, lv_sts_lookup_code_argument2)
571: and aca.org_id in
572: (
573: select organization_id org_id
574: from JAI_AP_TDS_ORG_TAN_V
575: where org_tan_num = pv_org_tan_num
576: --Removed the union code by Bgowrava for Bug#6129650
577: )
578: and jattt.tds_authority_vendor_id = nvl(pn_tds_authority_id, jattt.tds_authority_vendor_id)