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.CE_PURGE dependencies on CE_BANK_BRANCHES_V

Line 69: p_Bank_Name ce_bank_branches_v.bank_name%TYPE,

65: p_BANK_ACCOUNT_ID ce_bank_accounts.BANK_ACCOUNT_ID%TYPE,
66: p_BANK_BRANCH_ID ce_bank_accounts.BANK_branch_ID%TYPE,
67: p_STATEMENT_DATE_FROM ce_statement_headers.statement_date%TYPE,
68: p_STATEMENT_DATE_TO ce_statement_headers.statement_date%TYPE,
69: p_Bank_Name ce_bank_branches_v.bank_name%TYPE,
70: p_Bank_Branch_Name ce_bank_branches_v.bank_branch_name%TYPE,
71: p_Bank_Account_Name ce_bank_accounts.Bank_Account_Name%TYPE,
72: p_Currency_Code ce_bank_accounts.Currency_Code%TYPE,
73: p_Bank_Account_Num ce_bank_accounts.Bank_Account_Num%TYPE,

Line 70: p_Bank_Branch_Name ce_bank_branches_v.bank_branch_name%TYPE,

66: p_BANK_BRANCH_ID ce_bank_accounts.BANK_branch_ID%TYPE,
67: p_STATEMENT_DATE_FROM ce_statement_headers.statement_date%TYPE,
68: p_STATEMENT_DATE_TO ce_statement_headers.statement_date%TYPE,
69: p_Bank_Name ce_bank_branches_v.bank_name%TYPE,
70: p_Bank_Branch_Name ce_bank_branches_v.bank_branch_name%TYPE,
71: p_Bank_Account_Name ce_bank_accounts.Bank_Account_Name%TYPE,
72: p_Currency_Code ce_bank_accounts.Currency_Code%TYPE,
73: p_Bank_Account_Num ce_bank_accounts.Bank_Account_Num%TYPE,
74: p_Archive_Purge_Option VARCHAR2,

Line 302: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba

298: WHERE cal.statement_number ||'-'|| cal.bank_account_num IN
299: ( SELECT csh.statement_number ||'-'|| csh.bank_account_num
300: FROM ce_statement_headers_int csh
301: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN (SELECT bb.bank_branch_name
302: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
303: WHERE bb.branch_party_id = ba.bank_branch_id
304: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
305: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
306: AND csh.bank_account_num IN (SELECT bank_account_num

Line 325: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba

321: ( SELECT csh.statement_number ||'-'|| csh.bank_account_num
322: FROM ce_statement_headers_int csh
323: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN
324: (SELECT bb.bank_branch_name
325: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
326: WHERE bb.branch_party_id = ba.bank_branch_id
327: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
328: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
329: AND csh.bank_account_num IN

Line 398: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba

394: ( SELECT csh.statement_number ||'-'|| csh.bank_account_num
395: FROM ce_statement_headers_int csh
396: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN (
397: SELECT bb.bank_branch_name
398: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
399: WHERE bb.branch_party_id = ba.bank_branch_id
400: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
401: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
402: AND csh.bank_account_num IN

Line 423: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba

419: (SELECT csh.statement_number ||'-'|| csh.bank_account_num
420: FROM ce_statement_headers_int csh
421: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN
422: (SELECT bb.bank_branch_name
423: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
424: WHERE bb.branch_party_id = ba.bank_branch_id
425: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
426: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
427: AND csh.bank_account_num IN

Line 1190: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba

1186: INTRA_DAY_FLAG
1187: --ORG_ID
1188: FROM ce_statement_headers_int csh
1189: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN (SELECT bb.bank_branch_name
1190: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
1191: WHERE bb.branch_party_id = ba.bank_branch_id
1192: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
1193: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
1194: AND csh.bank_account_num IN (SELECT bank_account_num

Line 1291: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba

1287: WHERE csl.statement_number ||'-'|| csl.bank_account_num IN (
1288: SELECT csh.statement_number ||'-'|| csh.bank_account_num
1289: FROM ce_statement_headers_int csh
1290: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN (SELECT bb.bank_branch_name
1291: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
1292: WHERE bb.branch_party_id = ba.bank_branch_id
1293: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
1294: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
1295: AND csh.bank_account_num IN (SELECT cv.bank_account_num

Line 1905: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba

1901: WHERE csl.statement_number ||'-'|| csl.bank_account_num IN
1902: ( SELECT csh.statement_number ||'-'|| csh.bank_account_num
1903: FROM ce_statement_headers_int csh
1904: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN (SELECT bb.bank_branch_name
1905: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
1906: WHERE bb.branch_party_id = ba.bank_branch_id
1907: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
1908: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
1909: AND csh.bank_account_num IN (SELECT bank_account_num

Line 1923: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba

1919:
1920: DELETE FROM ce_statement_headers_int csh
1921: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN
1922: (SELECT bb.bank_branch_name
1923: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
1924: WHERE bb.branch_party_id = ba.bank_branch_id
1925: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
1926: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
1927: AND csh.bank_account_num IN

Line 2000: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba

1996: WHERE csl.statement_number ||'-'|| csl.bank_account_num IN
1997: ( SELECT csh.statement_number ||'-'|| csh.bank_account_num
1998: FROM ce_statement_headers_int csh
1999: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN (SELECT bb.bank_branch_name
2000: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
2001: WHERE bb.branch_party_id = ba.bank_branch_id
2002: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
2003: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
2004: AND csh.bank_account_num IN

Line 2019: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba

2015:
2016: DELETE FROM ce_statement_headers_int csh
2017: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN
2018: (SELECT bb.bank_branch_name
2019: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
2020: WHERE bb.branch_party_id = ba.bank_branch_id
2021: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
2022: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
2023: AND csh.bank_account_num IN

Line 2861: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba

2857: intra_day_flag,
2858: ORG_ID
2859: FROM ce_arch_interface_headers csh
2860: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN (SELECT bb.bank_branch_name
2861: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
2862: WHERE bb.branch_party_id = ba.bank_branch_id
2863: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)
2864: AND bb.branch_party_id = NVL(CE_PURGE.G_BANK_BRANCH_ID, bb.branch_party_id))
2865: AND csh.bank_account_num IN (SELECT bank_account_num

Line 2914: FROM ce_bank_Branches_v

2910: INTO l_bank_account_name
2911: FROM ce_bank_accounts ce
2912: WHERE ce.bank_account_num = r_interface.bank_account_num
2913: AND ce.bank_branch_id=(SELECT Branch_party_id
2914: FROM ce_bank_Branches_v
2915: WHERE bank_branch_name = Nvl(r_interface.BANK_BRANCH_NAME,G_BANK_BRANCH_NAME))
2916: AND ce.currency_code=r_interface.CURRENCY_CODE ;
2917: END IF;
2918:

Line 3274: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba

3270: G_Bank_Branch_Name,
3271: G_Bank_Account_Name,
3272: G_Bank_Account_Num,
3273: G_Currency_Code
3274: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
3275: WHERE ba.bank_account_id = G_BANK_ACCOUNT_ID
3276: AND bb.branch_party_id = ba.bank_branch_id;
3277:
3278:

Line 3284: FROM ce_bank_branches_v bb

3280: SELECT bb.bank_name,
3281: bb.bank_branch_name
3282: INTO G_Bank_Name,
3283: G_Bank_Branch_Name
3284: FROM ce_bank_branches_v bb
3285: WHERE bb.branch_party_id = G_BANK_BRANCH_ID;
3286:
3287: END IF;
3288: --