DBA Data[Home] [Help]

APPS.JAI_AP_TDS_ETDS_PKG dependencies on HZ_ORGANIZATION_PROFILES

Line 230: v_bank_branch_code HZ_ORGANIZATION_PROFILES.BANK_OR_BRANCH_NUMBER%TYPE;

226: v_base_check_date DATE;
227: v_tds_check_date DATE;
228: v_challan_num VARCHAR2(50);
229: v_challan_date DATE;
230: v_bank_branch_code HZ_ORGANIZATION_PROFILES.BANK_OR_BRANCH_NUMBER%TYPE;
231:
232: v_challan_err VARCHAR2(100);
233: v_deductee_err VARCHAR2(100);
234:

Line 366: FROM HZ_ORGANIZATION_PROFILES HZOP

362:
363: /* Following cursor is modified by Brathod for Bug# 4428712 (R12 Initiative)
364: CURSOR c_bank_branch_code(p_bank_account_id IN NUMBER) IS
365: SELECT HZOP.BANK_OR_BRANCH_NUMBER
366: FROM HZ_ORGANIZATION_PROFILES HZOP
367: , CE_BANK_ACCOUNTS CEBA
368: WHERE HZOP.PARTY_ID = CEBA.BANK_BRANCH_ID
369: AND CEBA.BANK_ACCOUNT_ID = p_bank_account_id;*/
370: