DBA Data[Home] [Help]

APPS.IGS_AD_WRKFLOW_PKG dependencies on IGS_AD_APPL_ALL

Line 1142: from igs_ad_appl_all a,

1138: l_alt_code_adm igs_ca_inst.alternate_code%TYPE;
1139:
1140: Cursor c_per_adm_req IS
1141: select a.person_id
1142: from igs_ad_appl_all a,
1143: igs_ad_ps_appl_inst_all i,
1144: igs_ad_aplins_admreq r,
1145: igs_tr_item_all t,
1146: igs_tr_type_all ty

Line 1179: from igs_ad_appl_all a,

1175: Group by a.person_id;
1176:
1177: Cursor c_per_post_adm_req IS
1178: select a.person_id
1179: from igs_ad_appl_all a,
1180: igs_ad_ps_appl_inst_all i,
1181: igs_ad_aplins_admreq r,
1182: igs_tr_item_all t,
1183: igs_tr_type_all ty

Line 1220: CURSOR cur_user(cp_person_id igs_ad_appl_all.person_id%TYPE) IS

1216: FROM IGS_CA_INST
1217: WHERE cal_type = cp_cal_type AND
1218: sequence_number = cp_seq_no;
1219:
1220: CURSOR cur_user(cp_person_id igs_ad_appl_all.person_id%TYPE) IS
1221: SELECT user_name, description
1222: FROM FND_USER
1223: WHERE person_party_id = cp_person_id ;
1224: