DBA Data[Home] [Help]

APPS.IGS_AD_ADM_REQ dependencies on IGS_AD_APCTR_RU

Line 932: FROM igs_ad_apctr_ru

928: WHERE person_id = p_person_id;
929:
930: CURSOR c_rule IS
931: SELECT rul_sequence_number
932: FROM igs_ad_apctr_ru
933: WHERE admission_cat = p_admission_cat
934: AND s_admission_process_type = p_admission_process_type
935: AND s_rule_call_cd = p_adm_rule_type;
936:

Line 1106: lv_rul_sequence_number igs_ad_apctr_ru.rul_sequence_number%TYPE;

1102:
1103: --Variable to know whether the IF Condition is satisfied
1104: lv_if_sat VARCHAR2(1);
1105:
1106: lv_rul_sequence_number igs_ad_apctr_ru.rul_sequence_number%TYPE;
1107:
1108:
1109: FUNCTION is_rul_item_exists ( p_rul_seq_num NUMBER, p_rul_item_seq_num_set VARCHAR2) RETURN BOOLEAN IS
1110: