APPS.JAI_AP_DTC_CANCELLATION_PKG dependencies on JAI_AP_TDS_INV_TAXES

Line 101: cursor c_jai_ap_tds_inv_taxes(p_invoice_id number,

97: select set_of_books_id, invoice_currency_code, exchange_rate
98: from ap_invoices_all
99: where invoice_id = p_invoice_id;
100:
101: cursor c_jai_ap_tds_inv_taxes(p_invoice_id number,
102: cp_section_type jai_ap_tds_inv_taxes.section_type%type) is --rchandan for bug#4428980
103: select threshold_grp_id,
104: sum(amount) taxable_amount,
105: sum(tax_amount) tax_amount

Line 102: cp_section_type jai_ap_tds_inv_taxes.section_type%type) is --rchandan for bug#4428980

98: from ap_invoices_all
99: where invoice_id = p_invoice_id;
100:
101: cursor c_jai_ap_tds_inv_taxes(p_invoice_id number,
102: cp_section_type jai_ap_tds_inv_taxes.section_type%type) is --rchandan for bug#4428980
103: select threshold_grp_id,
104: sum(amount) taxable_amount,
105: sum(tax_amount) tax_amount
106: from jai_ap_tds_inv_taxes jtdsi

Line 106: from jai_ap_tds_inv_taxes jtdsi

102: cp_section_type jai_ap_tds_inv_taxes.section_type%type) is --rchandan for bug#4428980
103: select threshold_grp_id,
104: sum(amount) taxable_amount,
105: sum(tax_amount) tax_amount
106: from jai_ap_tds_inv_taxes jtdsi
107: where invoice_id = p_invoice_id
108: and section_type = cp_section_type --cp_section_type--rchandan for bug#4428980
109: and threshold_grp_id is not null
110: and threshold_trx_id is null

Line 141: from jai_ap_tds_inv_taxes jatit, jai_ap_tds_thhold_trxs jattt

137: cursor c_threshold_breach(p_invoice_id number) is
138: select jattt.invoice_id,
139: jattt.tds_event,
140: jattt.invoice_to_tds_authority_id
141: from jai_ap_tds_inv_taxes jatit, jai_ap_tds_thhold_trxs jattt
142: where jatit.invoice_id = p_invoice_id
143: and jatit.default_cum_threshold_stage = 'BEFORE THRESHOLD'
144: and jatit.threshold_grp_id = jattt.threshold_grp_id
145: and jattt.tds_event like 'THRESHOLD%'

Line 1008: for cur_rec in c_jai_ap_tds_inv_taxes(p_invoice_id, 'TDS_SECTION') --rchandan for bug#4428980

1004: goto exit_from_procedure;
1005: end if;
1006: Commented by Chong for ZX investigation 20120816*/
1007: /*End-ETDS FVU3.1 Bug 11896260*/
1008: for cur_rec in c_jai_ap_tds_inv_taxes(p_invoice_id, 'TDS_SECTION') --rchandan for bug#4428980
1009: loop
1010: --Fnd_File.put_line(Fnd_File.LOG, 'outer Loop');
1011: IF ( ln_proc_level >= ln_dbg_level)
1012: THEN