DBA Data[Home] [Help]

APPS.IGF_SL_GEN dependencies on IGS_PE_EIT_RESTATUS_V

Line 1062: igs_pe_eit_restatus_v pct

1058: IS
1059: SELECT lkup.tag,
1060: pct.restatus_code
1061: FROM igs_lookup_values lkup,
1062: igs_pe_eit_restatus_v pct
1063: WHERE lkup.lookup_type = cp_lookup_type
1064: AND lkup.lookup_code = pct.restatus_code
1065: AND pct.person_id = cp_person_id
1066: AND SYSDATE BETWEEN start_date AND NVL(end_date,SYSDATE)