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

Line 28: FROM ce_bank_branches_v

24: P_bank_number IN OUT NOCOPY VARCHAR2) IS
25:
26: CURSOR C_bank(X_bank_name VARCHAR2)IS
27: SELECT bank_number
28: FROM ce_bank_branches_v
29: WHERE bank_name = X_bank_name;
30:
31: l_debug_info Varchar2(2000);
32: l_api_name CONSTANT VARCHAR2(100) := 'GET_BANK_NUMBER';

Line 65: from ce_bank_branches_v

61: END IF;
62:
63: select bank_number, branch_number, bank_branch_name
64: into P_bank_number, P_branch_number, P_branch_name
65: from ce_bank_branches_v
66: where branch_party_id = p_bank_branch_id;
67:
68: exception
69: when NO_DATA_FOUND then

Line 600: FROM ce_bank_branches_v

596:
597:
598: CURSOR C_get_bank_name(X_bank_branch_id NUMBER) IS
599: SELECT bank_name
600: FROM ce_bank_branches_v
601: WHERE branch_party_id = X_bank_branch_id;
602:
603: CURSOR C_precision(X_currency_code VARCHAR2) IS
604: SELECT precision

Line 624: P_transferring_bank_name ce_bank_branches_v.bank_name%TYPE;

620: ORDER BY trans_amount_from desc;
621:
622:
623: P_bank_charge_id NUMBER;
624: P_transferring_bank_name ce_bank_branches_v.bank_name%TYPE;
625: P_receiving_bank_name ce_bank_branches_v.bank_name%TYPE;
626:
627: v_bank_charge_id NUMBER;
628: v_trans_bank_branch_id NUMBER;

Line 625: P_receiving_bank_name ce_bank_branches_v.bank_name%TYPE;

621:
622:
623: P_bank_charge_id NUMBER;
624: P_transferring_bank_name ce_bank_branches_v.bank_name%TYPE;
625: P_receiving_bank_name ce_bank_branches_v.bank_name%TYPE;
626:
627: v_bank_charge_id NUMBER;
628: v_trans_bank_branch_id NUMBER;
629: v_trans_bank_name ce_bank_branches_v.bank_name%TYPE;

Line 629: v_trans_bank_name ce_bank_branches_v.bank_name%TYPE;

625: P_receiving_bank_name ce_bank_branches_v.bank_name%TYPE;
626:
627: v_bank_charge_id NUMBER;
628: v_trans_bank_branch_id NUMBER;
629: v_trans_bank_name ce_bank_branches_v.bank_name%TYPE;
630: v_trans_bank ce_bank_branches_v.bank_name%TYPE;
631: v_trans_branch ce_bank_branches_v.bank_branch_name%TYPE;
632: v_recei_bank_branch_id NUMBER;
633: v_recei_bank_name ce_bank_branches_v.bank_name%TYPE;

Line 630: v_trans_bank ce_bank_branches_v.bank_name%TYPE;

626:
627: v_bank_charge_id NUMBER;
628: v_trans_bank_branch_id NUMBER;
629: v_trans_bank_name ce_bank_branches_v.bank_name%TYPE;
630: v_trans_bank ce_bank_branches_v.bank_name%TYPE;
631: v_trans_branch ce_bank_branches_v.bank_branch_name%TYPE;
632: v_recei_bank_branch_id NUMBER;
633: v_recei_bank_name ce_bank_branches_v.bank_name%TYPE;
634: v_recei_bank ce_bank_branches_v.bank_name%TYPE;

Line 631: v_trans_branch ce_bank_branches_v.bank_branch_name%TYPE;

627: v_bank_charge_id NUMBER;
628: v_trans_bank_branch_id NUMBER;
629: v_trans_bank_name ce_bank_branches_v.bank_name%TYPE;
630: v_trans_bank ce_bank_branches_v.bank_name%TYPE;
631: v_trans_branch ce_bank_branches_v.bank_branch_name%TYPE;
632: v_recei_bank_branch_id NUMBER;
633: v_recei_bank_name ce_bank_branches_v.bank_name%TYPE;
634: v_recei_bank ce_bank_branches_v.bank_name%TYPE;
635: v_recei_branch ce_bank_branches_v.bank_branch_name%TYPE;

Line 633: v_recei_bank_name ce_bank_branches_v.bank_name%TYPE;

629: v_trans_bank_name ce_bank_branches_v.bank_name%TYPE;
630: v_trans_bank ce_bank_branches_v.bank_name%TYPE;
631: v_trans_branch ce_bank_branches_v.bank_branch_name%TYPE;
632: v_recei_bank_branch_id NUMBER;
633: v_recei_bank_name ce_bank_branches_v.bank_name%TYPE;
634: v_recei_bank ce_bank_branches_v.bank_name%TYPE;
635: v_recei_branch ce_bank_branches_v.bank_branch_name%TYPE;
636: v_transfer_priority VARCHAR2(30);
637: v_currency_code VARCHAR2(15);

Line 634: v_recei_bank ce_bank_branches_v.bank_name%TYPE;

630: v_trans_bank ce_bank_branches_v.bank_name%TYPE;
631: v_trans_branch ce_bank_branches_v.bank_branch_name%TYPE;
632: v_recei_bank_branch_id NUMBER;
633: v_recei_bank_name ce_bank_branches_v.bank_name%TYPE;
634: v_recei_bank ce_bank_branches_v.bank_name%TYPE;
635: v_recei_branch ce_bank_branches_v.bank_branch_name%TYPE;
636: v_transfer_priority VARCHAR2(30);
637: v_currency_code VARCHAR2(15);
638:

Line 635: v_recei_branch ce_bank_branches_v.bank_branch_name%TYPE;

631: v_trans_branch ce_bank_branches_v.bank_branch_name%TYPE;
632: v_recei_bank_branch_id NUMBER;
633: v_recei_bank_name ce_bank_branches_v.bank_name%TYPE;
634: v_recei_bank ce_bank_branches_v.bank_name%TYPE;
635: v_recei_branch ce_bank_branches_v.bank_branch_name%TYPE;
636: v_transfer_priority VARCHAR2(30);
637: v_currency_code VARCHAR2(15);
638:
639: priority NUMBER;

Line 987: FROM ce_bank_branches_v

983: to_date('31-12-4712', 'DD-MM-YYYY')) > P_transaction_date;
984:
985: CURSOR C_get_bank_name(X_bank_branch_id NUMBER) IS
986: SELECT bank_name
987: FROM ce_bank_branches_v
988: WHERE branch_party_id = X_bank_branch_id;
989:
990: CURSOR C_precision(X_currency_code VARCHAR2) IS
991: SELECT precision

Line 1011: P_transferring_bank_name ce_bank_branches_v.bank_name%TYPE;

1007: ORDER BY trans_amount_from desc;
1008:
1009:
1010: P_bank_charge_id NUMBER;
1011: P_transferring_bank_name ce_bank_branches_v.bank_name%TYPE;
1012: P_receiving_bank_name ce_bank_branches_v.bank_name%TYPE;
1013:
1014: v_bank_charge_id NUMBER;
1015: v_trans_bank_branch_id NUMBER;

Line 1012: P_receiving_bank_name ce_bank_branches_v.bank_name%TYPE;

1008:
1009:
1010: P_bank_charge_id NUMBER;
1011: P_transferring_bank_name ce_bank_branches_v.bank_name%TYPE;
1012: P_receiving_bank_name ce_bank_branches_v.bank_name%TYPE;
1013:
1014: v_bank_charge_id NUMBER;
1015: v_trans_bank_branch_id NUMBER;
1016: v_trans_bank_name ce_bank_branches_v.bank_name%TYPE;

Line 1016: v_trans_bank_name ce_bank_branches_v.bank_name%TYPE;

1012: P_receiving_bank_name ce_bank_branches_v.bank_name%TYPE;
1013:
1014: v_bank_charge_id NUMBER;
1015: v_trans_bank_branch_id NUMBER;
1016: v_trans_bank_name ce_bank_branches_v.bank_name%TYPE;
1017: v_trans_bank ce_bank_branches_v.bank_name%TYPE;
1018: v_trans_branch ce_bank_branches_v.bank_branch_name%TYPE;
1019: v_recei_bank_branch_id NUMBER;
1020: v_recei_bank_name ce_bank_branches_v.bank_name%TYPE;

Line 1017: v_trans_bank ce_bank_branches_v.bank_name%TYPE;

1013:
1014: v_bank_charge_id NUMBER;
1015: v_trans_bank_branch_id NUMBER;
1016: v_trans_bank_name ce_bank_branches_v.bank_name%TYPE;
1017: v_trans_bank ce_bank_branches_v.bank_name%TYPE;
1018: v_trans_branch ce_bank_branches_v.bank_branch_name%TYPE;
1019: v_recei_bank_branch_id NUMBER;
1020: v_recei_bank_name ce_bank_branches_v.bank_name%TYPE;
1021: v_recei_bank ce_bank_branches_v.bank_name%TYPE;

Line 1018: v_trans_branch ce_bank_branches_v.bank_branch_name%TYPE;

1014: v_bank_charge_id NUMBER;
1015: v_trans_bank_branch_id NUMBER;
1016: v_trans_bank_name ce_bank_branches_v.bank_name%TYPE;
1017: v_trans_bank ce_bank_branches_v.bank_name%TYPE;
1018: v_trans_branch ce_bank_branches_v.bank_branch_name%TYPE;
1019: v_recei_bank_branch_id NUMBER;
1020: v_recei_bank_name ce_bank_branches_v.bank_name%TYPE;
1021: v_recei_bank ce_bank_branches_v.bank_name%TYPE;
1022: v_recei_branch ce_bank_branches_v.bank_branch_name%TYPE;

Line 1020: v_recei_bank_name ce_bank_branches_v.bank_name%TYPE;

1016: v_trans_bank_name ce_bank_branches_v.bank_name%TYPE;
1017: v_trans_bank ce_bank_branches_v.bank_name%TYPE;
1018: v_trans_branch ce_bank_branches_v.bank_branch_name%TYPE;
1019: v_recei_bank_branch_id NUMBER;
1020: v_recei_bank_name ce_bank_branches_v.bank_name%TYPE;
1021: v_recei_bank ce_bank_branches_v.bank_name%TYPE;
1022: v_recei_branch ce_bank_branches_v.bank_branch_name%TYPE;
1023: v_transfer_priority VARCHAR2(30);
1024: v_currency_code VARCHAR2(15);

Line 1021: v_recei_bank ce_bank_branches_v.bank_name%TYPE;

1017: v_trans_bank ce_bank_branches_v.bank_name%TYPE;
1018: v_trans_branch ce_bank_branches_v.bank_branch_name%TYPE;
1019: v_recei_bank_branch_id NUMBER;
1020: v_recei_bank_name ce_bank_branches_v.bank_name%TYPE;
1021: v_recei_bank ce_bank_branches_v.bank_name%TYPE;
1022: v_recei_branch ce_bank_branches_v.bank_branch_name%TYPE;
1023: v_transfer_priority VARCHAR2(30);
1024: v_currency_code VARCHAR2(15);
1025:

Line 1022: v_recei_branch ce_bank_branches_v.bank_branch_name%TYPE;

1018: v_trans_branch ce_bank_branches_v.bank_branch_name%TYPE;
1019: v_recei_bank_branch_id NUMBER;
1020: v_recei_bank_name ce_bank_branches_v.bank_name%TYPE;
1021: v_recei_bank ce_bank_branches_v.bank_name%TYPE;
1022: v_recei_branch ce_bank_branches_v.bank_branch_name%TYPE;
1023: v_transfer_priority VARCHAR2(30);
1024: v_currency_code VARCHAR2(15);
1025:
1026: priority NUMBER;