DBA Data[Home] [Help]

APPS.JAI_AP_IDA_TRIGGER_DTC_PKG dependencies on JAI_AP_TDS_THHOLD_TRXS

Line 130: FROM jai_ap_tds_thhold_trxs

126: CURSOR c_tds_invoice_id(cp_invoice_id NUMBER)
127: IS
128: SELECT invoice_to_tds_authority_id invoice_id,
129: invoice_to_tds_authority_num invoice_num
130: FROM jai_ap_tds_thhold_trxs
131: WHERE invoice_id = cp_invoice_id;
132:
133: /* Bug 8330522. Added by Lakshmi Gopalsami */
134:

Line 139: FROM jai_ap_tds_thhold_trxs

135: CURSOR c_tds_invoice_id1(cp_invoice_to_vendor_id NUMBER)
136: IS
137: SELECT invoice_to_tds_authority_id invoice_id,
138: invoice_to_tds_authority_num invoice_num
139: FROM jai_ap_tds_thhold_trxs
140: WHERE invoice_to_vendor_id = cp_invoice_to_vendor_id;
141: -- end for bug 83305222.
142:
143: r_tds_invoice_id c_tds_invoice_id%ROWTYPE;