DBA Data[Home] [Help]

APPS.IGI_STP_CREATE_PCK_PKG dependencies on IGI_STP_NET_TYPE_ALLOC_ALL

Line 152: igi_stp_net_type_alloc_all net

148: exchange_rate,
149: exchange_rate_type,
150: exchange_date
151: FROM igi_stp_candidates_all cand,
152: igi_stp_net_type_alloc_all net
153: WHERE cand.batch_id = p_batch_id
154: AND cand.package_id = p_package_id
155: AND cand.netting_trx_type_id = p_netting_trx_type_id
156: AND cand.process_flag = 'S'

Line 333: FROM igi_stp_net_type_alloc_ALL net

329: -1 ,
330: sysdate ,
331: -1 ,
332: sysdate
333: FROM igi_stp_net_type_alloc_ALL net
334: WHERE net.netting_trx_type_id = l_netting_trx_type_id
335: AND net.application = decode(l_application,'AP', 'SQLAP',l_application)
336: AND net.trx_type_class = l_trx_type_class
337: AND ORG_ID = P_ORG_ID;