DBA Data[Home] [Help]

APPS.JAI_AP_TDS_PROCESSING_PKG dependencies on JAI_AP_TDS_ORG_TAN_V

Line 220: from JAI_AP_TDS_ORG_TAN_V

216: )
217: and aca.org_id in
218: (
219: select organization_id org_id
220: from JAI_AP_TDS_ORG_TAN_V
221: where org_tan_num = pv_org_tan_num
222: --Removed the union code by Bgowrava for Bug#6129650
223: )
224: and jattt.tds_authority_vendor_id = nvl(pn_tds_authority_id, jattt.tds_authority_vendor_id)

Line 295: from JAI_AP_TDS_ORG_TAN_V

291: )
292: and aca.org_id in
293: (
294: select organization_id org_id
295: from JAI_AP_TDS_ORG_TAN_V
296: where org_tan_num = pv_org_tan_num
297: --Removed the union code by Bgowrava for Bug#6129650
298: )
299: and not exists (

Line 425: from JAI_AP_TDS_ORG_TAN_V

421: and aia.vendor_site_id = nvl(pn_tds_authority_site_id, aia.vendor_site_id)
422: and aia.org_id in
423: (
424: select organization_id org_id
425: from JAI_AP_TDS_ORG_TAN_V
426: where org_tan_num = pv_org_tan_num
427: --Removed the union code by Bgowrava for Bug#6129650
428: )
429: and not exists (

Line 587: from JAI_AP_TDS_ORG_TAN_V

583: and aca.status_lookup_code NOT IN (lv_sts_lookup_code_argument1, lv_sts_lookup_code_argument2)
584: and aca.org_id in
585: (
586: select organization_id org_id
587: from JAI_AP_TDS_ORG_TAN_V
588: where org_tan_num = pv_org_tan_num
589: --Removed the union code by Bgowrava for Bug#6129650
590: )
591: and jattt.tds_authority_vendor_id = nvl(pn_tds_authority_id, jattt.tds_authority_vendor_id)