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_DEFAULTATION_PKG dependencies on JAI_AP_TDS_THHOLD_ACCOUNT

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

570: cp_threshold_type varchar2,
571: cp_amount number,
572: cp_max_accounting_date date,
573: cp_min_accounting_date date
574: ,cp_legal_entity_id JAI_AP_TDS_THHOLD_ACCOUNT.LEGAL_ENTITY_ID%TYPE --Added cp_legal_entity_id by Chong for Bug#13802244 2012/09/21
575: ,cp_tds_section_code jai_ap_tds_default.TDS_SECTION_CODE%TYPE --Added cp_tds_section_code by Chong for Bug#13802244 2012/09/21
576: ,cp_natural_account_value jai_ap_tds_default.natural_account_value%TYPE --Added by Chong for Bug#15939571 2012/12/12
577: ,cp_accounting_date Date --Added by Chong for Bug#15939571 2012/12/12
578: )

Line 601: from JAI_AP_TDS_THHOLD_ACCOUNT jatta

597: --Added by Chong for bug#15964390 20121212 End
598: and exists (select '1'
599: --Added by Chong for bug#15939571 20121212 Start
600: ------------------------------------------------
601: from JAI_AP_TDS_THHOLD_ACCOUNT jatta
602: ,JAI_DTC_SCTN_ACCOUNT_MAPPING jdsam
603: where jatta.threshold_hdr_id = jattt.threshold_hdr_id
604: and jatta.threshold_type_id = jattt.threshold_type_id
605: and jatta.legal_entity_id = jdsam.legal_entity_id

Line 614: from JAI_AP_TDS_THHOLD_ACCOUNT jatta

610: and cp_accounting_date between nvl(jdsam.from_date,cp_accounting_date) and nvl(jdsam.to_date, cp_accounting_date)
611: ------------------------------------------------
612: --Added by Chong for bug#15939571 20121212 End
613: /* --Commented by Chong for bug#15939571 20121213 Start
614: from JAI_AP_TDS_THHOLD_ACCOUNT jatta
615: where jatta.threshold_hdr_id = jattt.threshold_hdr_id --Added alias (jattt) by Chong for Bug#13802244 2012/09/21
616: and jatta.threshold_type_id = jattt.threshold_type_id
617: and jatta.legal_entity_id = cp_legal_entity_id --Added cp_legal_entity_id by Chong for Bug#13802244 2012/09/21
618: and jatta.NATURAL_ACCOUNT_VALUE in (select distinct natural_account_value

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

700: from ap_invoice_lines_all
701: where invoice_id = p_inv_id
702: and match_type <> 'NOT_MATCHED';
703:
704: cursor c_check_effective_date(cp_legal_entity_id JAI_AP_TDS_THHOLD_ACCOUNT.LEGAL_ENTITY_ID%TYPE
705: ,cp_tds_section_code jai_ap_tds_default.TDS_SECTION_CODE%TYPE
706: ,cp_natural_account_value jai_ap_tds_default.natural_account_value%TYPE
707: ,cp_accounting_date DATE
708: ) is

Line 1335: from JAI_AP_TDS_THHOLD_ACCOUNT jatta

1331: AND natural_account_value = get_grp_sec_act_rec.natural_account_value
1332: AND accounting_date = get_grp_sec_act_rec.accounting_date
1333: AND EXISTS (
1334: SELECT 1
1335: from JAI_AP_TDS_THHOLD_ACCOUNT jatta
1336: ,JAI_DTC_SCTN_ACCOUNT_MAPPING jdsam
1337: where jatta.threshold_hdr_id = thrd_details_rec.threshold_hdr_id
1338: and jatta.threshold_type_id = thrd_details_rec.threshold_type_id
1339: and jatta.legal_entity_id = jdsam.legal_entity_id

Line 1353: FROM JAI_AP_TDS_THHOLD_ACCOUNT

1349: --Added by Chong for bug#15939571 20121213 End
1350: /*Commented out by Chong for bug#15939571 20121213 Start
1351: AND NATURAL_ACCOUNT_VALUE IN
1352: (SELECT NATURAL_ACCOUNT_VALUE
1353: FROM JAI_AP_TDS_THHOLD_ACCOUNT
1354: WHERE THRESHOLD_HDR_ID = ln_thr_header_id
1355: AND THRESHOLD_TYPE_ID = thrd_details_rec.THRESHOLD_TYPE_ID
1356: AND LEGAL_ENTITY_ID = ln_legal_entity_id);
1357: Commented out by Chong for bug#15939571 20121213 End */