eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AP_DTC_GENERATION_PKG dependencies on JAI_AP_TDS_THHOLD_ACCOUNT

Line 2919: ,p_legal_entity_id JAI_AP_TDS_THHOLD_ACCOUNT.LEGAL_ENTITY_ID%TYPE --Added p_legal_entity_id by Chong for Bug#13802244 2012/09/21

2915: p_threshold_hdr_id number,
2916: p_threshold_type varchar2,
2917: p_amount number,
2918: p_natural_account varchar2
2919: ,p_legal_entity_id JAI_AP_TDS_THHOLD_ACCOUNT.LEGAL_ENTITY_ID%TYPE --Added p_legal_entity_id by Chong for Bug#13802244 2012/09/21
2920: )is
2921: select threshold_slab_id, threshold_type_id, from_amount, to_amount
2922: from jai_ap_tds_thhold_slabs
2923: where threshold_hdr_id = p_threshold_hdr_id

Line 2931: from JAI_AP_TDS_THHOLD_ACCOUNT jatta

2927: where jattt.threshold_hdr_id = p_threshold_hdr_id
2928: and jattt.threshold_type = p_threshold_type
2929: and trunc(p_accounting_Date) between jattt.from_date and nvl(jattt.to_date, p_accounting_date + 1)
2930: and exists (select '1'
2931: from JAI_AP_TDS_THHOLD_ACCOUNT jatta
2932: where jatta.threshold_hdr_id = jattt.threshold_hdr_id --Added alias (jattt) by Chong for Bug#13802244 2012/09/21
2933: and jatta.threshold_type_id = jattt.threshold_type_id
2934: and jatta.NATURAL_ACCOUNT_VALUE = p_natural_account
2935: and jatta.legal_entity_id = p_legal_entity_id --Added p_legal_entity_id by Chong for Bug#13802244 2012/09/21

Line 3108: cursor c_check_effective_date(cp_legal_entity_id JAI_AP_TDS_THHOLD_ACCOUNT.LEGAL_ENTITY_ID%TYPE

3104: from ap_invoice_lines_all
3105: where invoice_id = p_invoice_id
3106: and match_type <> 'NOT_MATCHED';
3107:
3108: cursor c_check_effective_date(cp_legal_entity_id JAI_AP_TDS_THHOLD_ACCOUNT.LEGAL_ENTITY_ID%TYPE
3109: ,cp_tds_section_code jai_ap_tds_default.TDS_SECTION_CODE%TYPE
3110: ,cp_natural_account_value jai_ap_tds_default.natural_account_value%TYPE
3111: ,cp_accounting_date DATE
3112: ) is

Line 9086: ,jai_ap_tds_thhold_account jatta

9082: jatts.from_amount,
9083: jatts.to_amount,
9084: jatts.tax_rate
9085: FROM jai_ap_tds_thhold_slabs jatts
9086: ,jai_ap_tds_thhold_account jatta
9087: ,jai_ap_tds_thhold_types jattt
9088: WHERE jatts.threshold_hdr_id = jatta.threshold_hdr_id
9089: AND jatts.threshold_type_id = jatta.threshold_type_id
9090: AND jattt.threshold_type_id = jatts.threshold_type_id

Line 9138: lv_natural_account jai_ap_tds_thhold_account.natural_account_value%TYPE;

9134: lv_invoice_distribution_id jai_ap_tds_inv_taxes.invoice_distribution_id%TYPE;
9135: lv_set_of_book_id NUMBER;
9136: lv_legal_entity_id NUMBER;
9137: lv_natural_account_segment VARCHAR2(100);
9138: lv_natural_account jai_ap_tds_thhold_account.natural_account_value%TYPE;
9139: r_CCID NUMBER;
9140: lv_proc_name VARCHAR2 (100) := 'get_tds_threshold_slab';
9141: ln_proc_level NUMBER := FND_LOG.level_procedure;
9142: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;