APPS.AHL_UMP_NONROUTINES_PVT dependencies on HZ_PARTIES

Line 3116: FROM hz_parties

3112: THEN
3113: BEGIN
3114: SELECT party_id, party_type
3115: INTO p_x_nonroutine_rec.customer_id, p_x_nonroutine_rec.customer_type
3116: FROM hz_parties
3117: WHERE status = 'A' AND
3118: party_type IN ('PERSON', 'ORGANIZATION') AND
3119: party_name = p_x_nonroutine_rec.customer_name AND
3120: party_id = NVL(p_x_nonroutine_rec.customer_id, party_id);

Line 3148: FROM hz_parties

3144: IF (p_x_nonroutine_rec.customer_id IS NOT NULL AND p_x_nonroutine_rec.customer_id <> FND_API.G_MISS_NUM)
3145: THEN
3146: SELECT party_name, party_type
3147: INTO p_x_nonroutine_rec.customer_name, p_x_nonroutine_rec.customer_type
3148: FROM hz_parties
3149: WHERE status = 'A' AND
3150: party_type IN ('PERSON', 'ORGANIZATION') AND
3151: party_id = p_x_nonroutine_rec.customer_id;
3152: END IF;

Line 3175: FROM hz_parties

3171: IF (p_x_nonroutine_rec.contact_type in ('PARTY_RELATIONSHIP', 'PERSON'))
3172: THEN
3173: SELECT party_id
3174: INTO p_x_nonroutine_rec.contact_id
3175: FROM hz_parties
3176: WHERE status = 'A' AND
3177: party_name = p_x_nonroutine_rec.contact_name;
3178: ELSIF (p_x_nonroutine_rec.contact_type = 'EMPLOYEE')
3179: THEN