APPS.IGS_SS_ENROLL_PKG dependencies on IGS_PS_UNIT_OFR_OPT

Line 71: from igs_ps_unit_ofr_opt

67: p_person_id ,
68: sysdate ,
69: p_person_id ,
70: p_org_id
71: from igs_ps_unit_ofr_opt
72: where cal_type = p_cal_type
73: and ci_sequence_number = p_ci_sequence_number
74: and call_number = p_call_number ;
75: if sql%rowcount = 0

Line 122: from igs_ps_unit_ofr_opt

118: begin
119: select
120: count(unit_cd)
121: into lv_count
122: from igs_ps_unit_ofr_opt
123: where cal_type = p_cal_type
124: and ci_sequence_number = p_ci_sequence_number
125: and lower(unit_cd) = lower(p_unit_cd)
126: and lower(unit_class) = lower(p_unit_class);

Line 180: from igs_ps_unit_ofr_opt

176: p_person_id ,
177: sysdate ,
178: p_person_id,
179: p_org_id
180: from igs_ps_unit_ofr_opt
181: where cal_type = p_cal_type
182: and ci_sequence_number = p_ci_sequence_number
183: and upper(unit_cd) = upper(p_unit_cd)
184: and upper(unit_class) = upper(p_unit_class) ;

Line 278: from igs_ps_unit_ofr_opt a

274: p_person_id,
275: sysdate,
276: p_person_id,
277: p_org_id
278: from igs_ps_unit_ofr_opt a
279: where uoo_id = p_uoo_id ;
280: exception
281: when dup_val_on_index
282: then

Line 431: from igs_ps_unit_ofr_opt a,igs_ca_inst b

427: sysdate,
428: p_person_id,
429: sysdate,
430: p_enrolled_cp
431: from igs_ps_unit_ofr_opt a,igs_ca_inst b
432: where a.uoo_id = p_uoo_id
433: and b.sequence_number = a.ci_sequence_number
434: and b.cal_type = a.cal_type ;
435: if sql%rowcount = 0