APPS.XTR_EFT_SCRIPT_P dependencies on XTR_SWIFT_EFT_V

Line 654: from XTR_SWIFT_EFT_V sw,

650: v_group_id NUMBER;
651: -- Gets applicable bank accounts
652: cursor HEADER_REC is
653: select distinct sw.company_acct_no
654: from XTR_SWIFT_EFT_V sw,
655: XTR_BANK_ACCOUNTS b,
656: XTR_SETTLEMENT_SCRIPTS s
657: where sw.settlement_date = NVL(trunc(settlement_date), sw.settlement_date)
658: and sw.company = l_company

Line 678: from XTR_SWIFT_EFT_V s

674: cparty_acct_no, cp_swift_id, cp_bank_name, cp_bank_street,
675: cp_bank_location, cp_name, cp_address1, cp_address2,
676: cp_address3, cp_corr_bank_name,cp_corr_bank_no,
677: s.settlement_summary_id, s.cparty
678: from XTR_SWIFT_EFT_V s
679: where trunc(s.settlement_date) = trunc(NVL(trunc(v_paydate), s.settlement_date))
680: and s.company_acct_no = v_account_no
681: and s.company = l_company
682: and s.cparty = nvl(l_cparty,s.cparty);

Line 972: from XTR_SWIFT_EFT_V sw,

968:
969: -- Gets applicable bank accounts
970: cursor HEADER_REC is
971: select distinct sw.company_acct_no
972: from XTR_SWIFT_EFT_V sw,
973: XTR_BANK_ACCOUNTS b,
974: XTR_SETTLEMENT_SCRIPTS s
975: where sw.settlement_date = NVL(trunc(settlement_date), sw.settlement_date)
976: and sw.company = l_company

Line 995: from XTR_SWIFT_EFT_V s

991: comp_bank_name, comp_bank_street, comp_bank_location,
992: cparty_acct_no, cp_swift_id, cp_bank_name, cp_bank_street,
993: cp_bank_location, cp_name, cp_address1, cp_address2,
994: cp_address3, s.company, s.cparty, s.settlement_summary_id
995: from XTR_SWIFT_EFT_V s
996: where trunc(s.settlement_date) = trunc(NVL(trunc(v_paydate), s.settlement_date))
997: and s.company_acct_no = v_account_no
998: and s.company = l_company
999: and s.cparty = nvl(l_cparty,s.cparty);