APPS.LNS_UTILITY_PUB dependencies on HZ_PARTIES

Line 1113: FROM hz_parties party, fnd_user fnduser

1109: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' :BEGIN');
1110: l_customer_contact_flag := 'N' ;
1111:
1112: SELECT 'Y' INTO l_customer_contact_flag
1113: FROM hz_parties party, fnd_user fnduser
1114: WHERE party.party_type = 'PARTY_RELATIONSHIP'
1115: AND party.status ='A'
1116: AND fnduser.customer_id = party.party_id
1117: AND fnduser.user_id = p_fnd_user_id;

Line 1155: FROM hz_parties party, fnd_user fnduser

1151: l_org_id := p_org_id;
1152:
1153:
1154: SELECT person_party_id INTO l_subject_id
1155: FROM hz_parties party, fnd_user fnduser
1156: WHERE party.party_type = 'PARTY_RELATIONSHIP'
1157: AND party.status ='A'
1158: AND fnduser.customer_id = party.party_id
1159: AND fnduser.user_id = l_fnd_user_id;

Line 1172: (SELECT party_id FROM hz_parties

1168: AND -- participant.hz_party_id in
1169: participant.loan_id in (SELECT loan_id FROM lns_participants p
1170: where p.hz_party_id
1171: in
1172: (SELECT party_id FROM hz_parties
1173: WHERE party_id in
1174: (SELECT object_id FROM hz_relationships
1175: WHERE subject_id = l_subject_id
1176: AND start_date <= sysdate