DBA Data[Home] [Help]

APPS.JAI_AP_DTC_DEFAULTATION_PKG dependencies on JAI_AP_TDS_THHOLD_TAXES

Line 340: JAI_AP_TDS_THHOLD_TAXES JATTTA

336: ,JATTH.THRESHOLD_HDR_ID --Added by Chong for bug#13740866 20121213
337: FROM JAI_AP_TDS_THHOLD_HDRS JATTH,
338: JAI_AP_TDS_THHOLD_TYPES JATTTY,
339: JAI_AP_TDS_THHOLD_SLABS JATTS,
340: JAI_AP_TDS_THHOLD_TAXES JATTTA
341: WHERE JATTH.THRESHOLD_HDR_ID = cp_thrd_header_id
342: AND JATTH.THRESHOLD_HDR_ID = JATTTY.THRESHOLD_HDR_ID
343: AND JATTTY.THRESHOLD_TYPE_ID = JATTS.THRESHOLD_TYPE_ID
344: AND JATTS.THRESHOLD_SLAB_ID = JATTTA.THRESHOLD_SLAB_ID

Line 632: FROM JAI_AP_TDS_THHOLD_TAXES

628: -- cursor to fetch tax category id
629: cursor c_tax_category_id (cp_thr_slab_id number, cp_org_id number)
630: is
631: SELECT TAX_CATEGORY_ID
632: FROM JAI_AP_TDS_THHOLD_TAXES
633: WHERE THRESHOLD_SLAB_ID = cp_thr_slab_id
634: AND OPERATING_UNIT_ID = cp_org_id;
635:
636: cursor c_sec_accounting_date (cp_sec_code varchar2)