DBA Data[Home] [Help]

APPS.CE_BASIG_WF dependencies on CE_BANK_BRANCHES_V

Line 28: g_bank_branch_name ce_bank_branches_v.bank_branch_name%type;

24: g_person_type CE_BA_SIGNATORIES_V.person_type%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:

Line 488: ce_bank_branches_v bb

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;
492: