APPS.XTR_NI_TRANSFERS_PKG dependencies on XTR_BANK_ACCOUNTS_V

Line 918: from xtr_bank_accounts_v

914: l_count NUMBER;
915: BEGIN
916: select count(*)
917: into l_count
918: from xtr_bank_accounts_v
919: where party_code = p_company_code
920: and currency = p_currency
921: and nvl(setoff_account_yn,'N') = 'N'
922: and account_number = p_account_no;

Line 941: from xtr_bank_accounts_v

937: return true;
938: end if;
939: select count(*)
940: into l_count
941: from xtr_bank_accounts_v
942: where currency = p_currency
943: and party_code = p_cparty_code
944: and account_number = p_cparty_account_no
945: and nvl(authorised,'N') = 'Y'

Line 2641: l_bank_code XTR_BANK_ACCOUNTS_V.BANK_CODE%TYPE;

2637: l_user xtr_dealer_codes.dealer_code%TYPE;
2638: l_dual_user xtr_dealer_codes.dealer_code%TYPE;
2639: l_dual_date DATE;
2640:
2641: l_bank_code XTR_BANK_ACCOUNTS_V.BANK_CODE%TYPE;
2642:
2643: cursor get_bank_issue_code(p_serial_number in NUMBER) is
2644: select bank_code
2645: from xtr_bill_bond_issues_v

Line 2652: from XTR_BANK_ACCOUNTS_V

2648:
2649:
2650: cursor get_bank_code is
2651: select BANK_CODE
2652: from XTR_BANK_ACCOUNTS_V
2653: where ACCOUNT_NUMBER = G_Ni_Main_Rec.Maturity_Account_No
2654: and PARTY_CODE = G_Ni_Main_Rec.Company_Code;
2655:
2656: