APPS.IGS_DA_TRNS_IMP dependencies on IGS_DA_CNFG_REQ_TYP

Line 3315: FROM igs_da_cnfg_req_typ

3311: IS
3312: CURSOR c_template
3313: IS
3314: SELECT request_type_id
3315: FROM igs_da_cnfg_req_typ
3316: WHERE request_name = 'Transfer Evaluation External Source'
3317: AND request_type = 'TE'
3318: AND closed_ind = 'N';
3319:

Line 3346: l_request_type_id igs_da_cnfg_req_typ.request_type_id%TYPE;

3342: FROM hz_parties, fnd_user
3343: WHERE fnd_user.customer_id = hz_parties.party_id
3344: AND fnd_user.user_id = fnd_profile.VALUE ('IGS_DA_WF_ADMIN');
3345:
3346: l_request_type_id igs_da_cnfg_req_typ.request_type_id%TYPE;
3347: l_batch_id igs_da_rqst.batch_id%TYPE;
3348: l_person_id hz_parties.party_id%TYPE;
3349: l_requestor_person_id hz_parties.party_id%TYPE;
3350: l_person_number hz_parties.party_number%TYPE;