DBA Data[Home] [Help]

APPS.LNS_BORROWERS_SUMMARY_PUB dependencies on HZ_CODE_ASSIGNMENTS

Line 163: HZ_CODE_ASSIGNMENTS ass

159: party.PRIMARY_PHONE_NUMBER,
160: party.PRIMARY_PHONE_EXTENSION,
161: party.CURR_FY_POTENTIAL_REVENUE
162: from hz_parties party,
163: HZ_CODE_ASSIGNMENTS ass
164: where party.party_id = P_PARTY_ID and
165: ass.OWNER_TABLE_NAME(+) = 'HZ_PARTIES' and
166: ass.OWNER_TABLE_ID(+) = party.party_id and
167: ass.CLASS_CATEGORY(+) = 'CUSTOMER_CATEGORY'and