DBA Data[Home] [Help]

APPS.IGS_AU_GEN_001 dependencies on IGS_AD_PS_APINTUNTHS

Line 341: p_unit_cd IN IGS_AD_PS_APINTUNTHS_ALL.unit_cd%TYPE ,

337: p_person_id IN NUMBER ,
338: p_admission_appl_number IN NUMBER ,
339: p_nominated_course_cd IN VARCHAR2 ,
340: p_acai_sequence_number IN NUMBER ,
341: p_unit_cd IN IGS_AD_PS_APINTUNTHS_ALL.unit_cd%TYPE ,
342: p_hist_end_dt IN DATE )
343: RETURN VARCHAR2 AS
344:
345: BEGIN

Line 382: FROM IGS_AD_PS_APINTUNTHS acaiuh

378: IGS_GE_DATE.igscharDT(acaiuh.rule_waived_dt),
379: cst_rule_waived_person_id, TO_CHAR(acaiuh.rule_waived_person_id),
380: cst_sup_unit_cd, acaiuh.sup_unit_cd,
381: cst_sup_uv_version_number, TO_CHAR(acaiuh.sup_uv_version_number))
382: FROM IGS_AD_PS_APINTUNTHS acaiuh
383: WHERE acaiuh.adm_ps_appl_inst_unit_id = p_adm_ps_appl_inst_unit_id AND
384: /*********************** 3083148 ***********************
385: acaiuh.person_id = p_person_id AND
386: acaiuh.admission_appl_number = p_admission_appl_number AND