DBA Data[Home] [Help]

APPS.JAI_AP_TDS_GENERATION_PKG dependencies on JAI_CMN_TAXES_ALL

Line 387: from JAI_CMN_TAXES_ALL

383: end_date,
384: sysdate,
385: 'Tax : ' || tax_name || ' is end dated as on ' || to_char(end_date, 'dd-mon-yyyy') ||
386: '. Setup needs modification.' tax_end_dated_message
387: from JAI_CMN_TAXES_ALL
388: where tax_id = p_tax_id;
389:
390: cursor c_for_each_tds_section(p_invoice_id number, p_exchange_rate number,p_section_type jai_ap_tds_inv_taxes.section_type%type) is--rchandan for bug#4428980
391: select actual_section_code, sum(amount*p_exchange_rate) invoice_amount, sum(tax_amount) section_amount

Line 1260: from JAI_CMN_TAXES_ALL

1256: tax_rate,
1257: stform_type,
1258: tax_account_id,
1259: section_type
1260: from JAI_CMN_TAXES_ALL
1261: where tax_id = pn_tax_id;
1262:
1263:
1264: cursor c_gl_sets_of_books(cp_set_of_books_id number) is

Line 1963: from JAI_CMN_TAXES_ALL

1959: where threshold_grp_id = cp_threshold_grp_id;
1960:
1961: cursor c_ja_in_tax_codes(cp_tax_id number) is
1962: select tax_rate
1963: from JAI_CMN_TAXES_ALL
1964: where tax_id = cp_tax_id;
1965:
1966: CURSOR get_thhold_rollbk (cp_threshold_grp_id IN NUMBER )
1967: IS