DBA Data[Home] [Help]

APPS.JAI_AP_IA_DTC_TRIGGER_PKG dependencies on JAI_AP_TDS_INV_TAXES

Line 78: from jai_ap_tds_inv_taxes jatit, jai_ap_tds_thhold_trxs jattt

74: cursor c_threshold_breach(p_invoice_id number) is
75: select jattt.invoice_id,
76: jattt.tds_event,
77: jattt.invoice_to_tds_authority_id
78: from jai_ap_tds_inv_taxes jatit, jai_ap_tds_thhold_trxs jattt
79: where jatit.invoice_id = p_invoice_id
80: and jatit.default_cum_threshold_stage = 'BEFORE THRESHOLD'
81: and jatit.threshold_grp_id = jattt.threshold_grp_id
82: and jattt.tds_event like 'THRESHOLD%'