APPS.IGF_AP_LG_TD_IMP dependencies on IGF_AP_TD_ITEM_INST_ALL

Line 797: FROM igf_ap_td_item_inst_all tdinst,

793: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE
794: )
795: IS
796: SELECT 1
797: FROM igf_ap_td_item_inst_all tdinst,
798: igf_ap_td_item_mst_all tdmst
799: WHERE tdinst.base_id = cp_base_id
800: AND tdinst.status IN ('INC','REQ','REC')
801: AND tdinst.required_for_application = 'Y'

Line 808: FROM igf_ap_td_item_inst_all tdinst,

804: AND tdmst.career_item = 'N'
805: AND ROWNUM < 2
806: UNION
807: SELECT 1
808: FROM igf_ap_td_item_inst_all tdinst,
809: igf_ap_td_item_mst_all tdmst,
810: igf_ap_fa_base_rec_all fa
811: WHERE tdinst.base_id = fa.base_id
812: AND tdinst.status IN ('INC','REQ','REC')