APPS.AHL_UMP_NONROUTINES_PVT dependencies on HZ_PARTIES

Line 2999: FROM hz_parties

2995: THEN
2996: BEGIN
2997: SELECT party_id, party_type
2998: INTO p_x_nonroutine_rec.customer_id, p_x_nonroutine_rec.customer_type
2999: FROM hz_parties
3000: WHERE status = 'A' AND
3001: party_type IN ('PERSON', 'ORGANIZATION') AND
3002: party_name = p_x_nonroutine_rec.customer_name AND
3003: party_id = NVL(p_x_nonroutine_rec.customer_id, party_id);

Line 3031: FROM hz_parties

3027: IF (p_x_nonroutine_rec.customer_id IS NOT NULL AND p_x_nonroutine_rec.customer_id <> FND_API.G_MISS_NUM)
3028: THEN
3029: SELECT party_name, party_type
3030: INTO p_x_nonroutine_rec.customer_name, p_x_nonroutine_rec.customer_type
3031: FROM hz_parties
3032: WHERE status = 'A' AND
3033: party_type IN ('PERSON', 'ORGANIZATION') AND
3034: party_id = p_x_nonroutine_rec.customer_id;
3035: END IF;

Line 3058: FROM hz_parties

3054: IF (p_x_nonroutine_rec.contact_type in ('PARTY_RELATIONSHIP', 'PERSON'))
3055: THEN
3056: SELECT party_id
3057: INTO p_x_nonroutine_rec.contact_id
3058: FROM hz_parties
3059: WHERE status = 'A' AND
3060: party_name = p_x_nonroutine_rec.contact_name;
3061: ELSIF (p_x_nonroutine_rec.contact_type = 'EMPLOYEE')
3062: THEN