APPS.CE_PURGE_TRX_CODES_XML dependencies on HZ_PARTIES

Line 31: FROM hz_parties BNK WHERE BNK.party_id = p_bank_id;

27: --bank
28: IF p_bank_id IS NOT NULL
29: THEN
30: SELECT SUBSTR(BNK.party_name,0,50) INTO g_bank_name
31: FROM hz_parties BNK WHERE BNK.party_id = p_bank_id;
32: ELSE
33: g_bank_name := NULL;
34: END IF;
35: debug_log('g_bank_name::'||g_bank_name);

Line 41: FROM hz_parties BRN WHERE BRN.party_id = p_bank_branch_id;

37: --bank branch
38: IF p_bank_branch_id IS NOT NULL
39: THEN
40: SELECT SUBSTR(BRN.party_name,0,50) INTO g_branch_name
41: FROM hz_parties BRN WHERE BRN.party_id = p_bank_branch_id;
42: ELSE
43: g_branch_name := NULL;
44: END IF;
45: debug_log('g_bank_branch_name::'||g_branch_name);