DBA Data[Home] [Help]

APPS.IGF_AP_BATCH_VER_PRC_PKG dependencies on IGF_AP_TD_ITEM_MST_ALL

Line 1793: igf_ap_td_item_mst_all tdmst

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'
1797: AND NVL(tdinst.inactive_flag,'N') <> 'Y'

Line 1804: igf_ap_td_item_mst_all tdmst,

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')
1808: AND tdinst.required_for_application = 'Y'