42: -- destination bank
43: IF p_dest_bank_id IS NOT NULL
44: THEN
45: SELECT SUBSTR(BNK.party_name,0,50) INTO g_dest_bank_name
46: FROM hz_parties BNK WHERE BNK.party_id = p_dest_bank_id;
47: ELSE
48: g_dest_bank_name := NULL;
49: END IF;
50: debug_log('g_dest_bank_name::'||g_dest_bank_name);
52: --destination branch
53: IF p_dest_branch_id IS NOT NULL
54: THEN
55: SELECT SUBSTR(BRN.party_name,0,50) INTO g_dest_branch_name
56: FROM hz_parties BRN WHERE BRN.party_id = p_dest_branch_id;
57: ELSE
58: g_dest_branch_name := NULL;
59: END IF;
60: debug_log('g_dest_branch_name::'||g_dest_branch_name);