APPS.OKL_SSC_WF dependencies on OKL_TRX_ASSETS

Line 699: OKL_TRX_ASSETS TRX

695: from OKL_TXL_ITM_INSTS INX,
696: OKX_PARTY_SITE_USES_V PSU1,
697: OKX_PARTY_SITE_USES_V PSU2,
698: OKL_TXL_ASSETS_B ASX,
699: OKL_TRX_ASSETS TRX
700: where
701: INX.TAS_ID = p_tas_id
702: AND INX.TAL_TYPE = p_tal_type
703: AND ASX.KLE_ID = INX.DNZ_CLE_ID

Line 916: l_trx_date OKL_TRX_ASSETS.DATE_TRANS_OCCURRED%TYPE;

912: l_new_location_id1 VARCHAR2(100);
913: l_new_location_id2 VARCHAR2(100);
914: l_old_location_id1 VARCHAR2(100);
915: l_old_location_id2 VARCHAR2(100);
916: l_trx_date OKL_TRX_ASSETS.DATE_TRANS_OCCURRED%TYPE;
917: l_asset_id OKC_K_LINES_V.ID%TYPE;
918: l_party_site_id okx_party_site_uses_v.PARTY_SITE_ID%TYPE;
919: l_location_id okx_party_site_uses_v.LOCATION_ID%TYPE;
920:

Line 922: l_trxv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;

918: l_party_site_id okx_party_site_uses_v.PARTY_SITE_ID%TYPE;
919: l_location_id okx_party_site_uses_v.LOCATION_ID%TYPE;
920:
921: l_loc_rec OKL_BLK_AST_UPD_PUB.blk_rec_type;
922: l_trxv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
923: x_trxv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
924:
925: CURSOR okl_loc_csr (p_id1 IN OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE, p_id2 IN OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE) IS
926: SELECT

Line 923: x_trxv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;

919: l_location_id okx_party_site_uses_v.LOCATION_ID%TYPE;
920:
921: l_loc_rec OKL_BLK_AST_UPD_PUB.blk_rec_type;
922: l_trxv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
923: x_trxv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
924:
925: CURSOR okl_loc_csr (p_id1 IN OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE, p_id2 IN OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE) IS
926: SELECT
927: PARTY_SITE_ID,