APPS.OKL_MAINTAIN_FEE_PVT dependencies on HZ_PARTIES

Line 1107: , hz_parties hz

1103: select hz.party_name
1104: from
1105: okc_k_lines_b cle
1106: , okc_k_headers_all_b chr
1107: , hz_parties hz
1108: , hz_cust_accounts hca
1109: where
1110: cle.chr_id = chr.id
1111: and chr.scs_code = 'INVESTOR'

Line 1123: , hz_parties hz

1119: select hz.party_id
1120: from
1121: okc_k_lines_b cle
1122: , okc_k_headers_all_b chr
1123: , hz_parties hz
1124: , hz_cust_accounts hca
1125: where
1126: cle.chr_id = chr.id
1127: and chr.scs_code = 'INVESTOR'

Line 1134: l_investor_name HZ_PARTIES.PARTY_NAME%TYPE;

1130: and hz.party_id = hca.party_id
1131: and hz.party_name = p_fee_types_rec.party_name
1132: and chr.id = p_fee_types_rec.dnz_chr_id;
1133:
1134: l_investor_name HZ_PARTIES.PARTY_NAME%TYPE;
1135: l_investor_id HZ_PARTIES.PARTY_ID%TYPE;
1136: l_is_ivestor NUMBER;
1137: -- Modified by zrehman for Bug#6763287 on 17-Jan-2008 end
1138: BEGIN

Line 1135: l_investor_id HZ_PARTIES.PARTY_ID%TYPE;

1131: and hz.party_name = p_fee_types_rec.party_name
1132: and chr.id = p_fee_types_rec.dnz_chr_id;
1133:
1134: l_investor_name HZ_PARTIES.PARTY_NAME%TYPE;
1135: l_investor_id HZ_PARTIES.PARTY_ID%TYPE;
1136: l_is_ivestor NUMBER;
1137: -- Modified by zrehman for Bug#6763287 on 17-Jan-2008 end
1138: BEGIN
1139: