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_BASIG_WF dependencies on CE_BA_SIGNATORIES_V

Line 24: g_person_type CE_BA_SIGNATORIES_V.person_type%TYPE;

20:
21: g_start_date DATE;
22: g_end_date DATE;
23: g_other_limits CE_BA_SIGNATORIES.OTHER_LIMITS%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;

Line 25: g_person_job CE_BA_SIGNATORIES_V.person_job%TYPE;

21: g_start_date DATE;
22: g_end_date DATE;
23: g_other_limits CE_BA_SIGNATORIES.OTHER_LIMITS%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;

Line 26: g_person_org_name CE_BA_SIGNATORIES_V.person_org_name%TYPE;

22: g_end_date DATE;
23: g_other_limits CE_BA_SIGNATORIES.OTHER_LIMITS%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;

Line 27: g_person_location CE_BA_SIGNATORIES_V.person_location%type;

23: g_other_limits CE_BA_SIGNATORIES.OTHER_LIMITS%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:

Line 30: g_signer_group CE_BA_SIGNATORIES_V.signer_group%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:
34: PROCEDURE initialize

Line 486: FROM ce_ba_signatories_v basv,

482: g_currency_code, g_bank_branch_name,
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