DBA Data[Home] [Help]

APPS.LNS_REP_UTILS dependencies on LNS_PARTICIPANTS

Line 1177: FROM LNS_PARTICIPANTS lp, HZ_PARTIES party, AR_LOOKUPS lkup, LNS_LOOKUPS lnslkup,

1173: )
1174: )
1175: )
1176: )
1177: FROM LNS_PARTICIPANTS lp, HZ_PARTIES party, AR_LOOKUPS lkup, LNS_LOOKUPS lnslkup,
1178: FND_TERRITORIES_TL ter, HZ_CONTACT_POINTS cp, HZ_PARTIES contact_person,
1179: HZ_PARTIES contact_party, HZ_CONTACT_POINTS con_phone
1180: WHERE party.party_id =lp.HZ_PARTY_ID
1181: AND party.party_type = lkup.lookup_code

Line 1272: LNS_PARTICIPANTS par

1268: LNS_LOOKUPS lkps4,
1269: LNS_LOOKUPS lkps5,
1270: LNS_LOOKUPS lkps6,
1271: HZ_PARTIES party,
1272: LNS_PARTICIPANTS par
1273: WHERE assetassign.asset_id = asset.asset_id and
1274: asset.asset_owner_id = par.hz_party_id and
1275: party.party_id = par.hz_party_id and
1276: assetassign.loan_id = par.loan_id and