APPS.OKL_MAINTAIN_FEE_PVT dependencies on HZ_PARTIES

Line 1116: , hz_parties hz

1112: select hz.party_name
1113: from
1114: okc_k_lines_b cle
1115: , okc_k_headers_all_b chr
1116: , hz_parties hz
1117: , hz_cust_accounts hca
1118: where
1119: cle.chr_id = chr.id
1120: and chr.scs_code = 'INVESTOR'

Line 1132: , hz_parties hz

1128: select hz.party_id
1129: from
1130: okc_k_lines_b cle
1131: , okc_k_headers_all_b chr
1132: , hz_parties hz
1133: , hz_cust_accounts hca
1134: where
1135: cle.chr_id = chr.id
1136: and chr.scs_code = 'INVESTOR'

Line 1143: l_investor_name HZ_PARTIES.PARTY_NAME%TYPE;

1139: and hz.party_id = hca.party_id
1140: and hz.party_name = p_fee_types_rec.party_name
1141: and chr.id = p_fee_types_rec.dnz_chr_id;
1142:
1143: l_investor_name HZ_PARTIES.PARTY_NAME%TYPE;
1144: l_investor_id HZ_PARTIES.PARTY_ID%TYPE;
1145: l_is_ivestor NUMBER;
1146: -- Modified by zrehman for Bug#6763287 on 17-Jan-2008 end
1147: BEGIN

Line 1144: l_investor_id HZ_PARTIES.PARTY_ID%TYPE;

1140: and hz.party_name = p_fee_types_rec.party_name
1141: and chr.id = p_fee_types_rec.dnz_chr_id;
1142:
1143: l_investor_name HZ_PARTIES.PARTY_NAME%TYPE;
1144: l_investor_id HZ_PARTIES.PARTY_ID%TYPE;
1145: l_is_ivestor NUMBER;
1146: -- Modified by zrehman for Bug#6763287 on 17-Jan-2008 end
1147: BEGIN
1148: