APPS.IGR_IMP_001 dependencies on IGR_IS_INQUIRY

Line 97: igr_is_inquiry inq

93: inq.attribute20,
94: inq.source_promotion_id
95: FROM
96: igr_is_person pe,
97: igr_is_inquiry inq
98: WHERE
99: pe.inq_person_id = inq.inq_person_id AND
100: inq.inquiry_type_id = p_inquiry_type_id AND
101: (

Line 1001: UPDATE igr_is_inquiry SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;

997: END IF;
998:
999: /* if all the validations are successful so far update the Status of
1000: Corresponding Self Service Records to Transferred (T) */
1001: UPDATE igr_is_inquiry SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;
1002: UPDATE igr_is_person SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;
1003:
1004: /* Now import the Child tables */
1005: -- kamohan 21-MAY-2002