DBA Data[Home] [Help]

APPS.IGF_AP_BATCH_VER_PRC_PKG dependencies on IGF_AP_TD_ITEM_INST_ALL

Line 1792: FROM igf_ap_td_item_inst_all tdinst,

1788: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1789: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE
1790: ) IS
1791: SELECT 1
1792: FROM igf_ap_td_item_inst_all tdinst,
1793: igf_ap_td_item_mst_all tdmst
1794: WHERE tdinst.base_id = p_base_id
1795: AND tdinst.status IN ('INC','REQ','REC')
1796: AND tdinst.required_for_application = 'Y'

Line 1803: FROM igf_ap_td_item_inst_all tdinst,

1799: AND tdmst.career_item = 'N'
1800: AND ROWNUM < 2
1801: UNION
1802: SELECT 1
1803: FROM igf_ap_td_item_inst_all tdinst,
1804: igf_ap_td_item_mst_all tdmst,
1805: igf_ap_fa_base_rec_all fa
1806: WHERE tdinst.base_id = fa.base_id
1807: AND tdinst.status IN ('INC','REQ','REC')