APPS.CE_BASIG_WF dependencies on CE_BANK_ACCOUNTS

Line 17: g_bank_account_name CE_BANK_ACCOUNTS.BANK_ACCOUNT_NAME%TYPE;

13: g_single_limit_amount NUMBER;
14: g_joint_limit_amount NUMBER;
15: l_signatory_id NUMBER;
16: g_signatory_name VARCHAR2(100);
17: g_bank_account_name CE_BANK_ACCOUNTS.BANK_ACCOUNT_NAME%TYPE;
18: g_currency_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
19: g_org_id NUMBER(15);
20:
21: g_start_date DATE;

Line 29: g_bank_account_number ce_bank_accounts.bank_Account_num%type;

25: g_person_job CE_BA_SIGNATORIES_V.person_job%TYPE;
26: g_person_org_name CE_BA_SIGNATORIES_V.person_org_name%TYPE;
27: g_person_location CE_BA_SIGNATORIES_V.person_location%type;
28: g_bank_branch_name ce_bank_branches_v.bank_branch_name%type;
29: g_bank_account_number ce_bank_accounts.bank_Account_num%type;
30: g_signer_group CE_BA_SIGNATORIES_V.signer_group%type;
31:
32:
33:

Line 487: ce_bank_accts_gt_v ba, --ce_bank_accounts_v ba,

483: g_person_type, g_person_job,
484: g_person_location, g_person_org_name,
485: g_start_Date, g_end_date
486: FROM ce_ba_signatories_v basv,
487: ce_bank_accts_gt_v ba, --ce_bank_accounts_v ba,
488: ce_bank_branches_v bb
489: WHERE basv.signatory_id = l_signatory_id
490: AND ba.bank_account_id = basv.bank_Account_id
491: AND bb.branch_party_id = ba.bank_branch_id;