APPS.CSI_FA_INSTANCE_GRP dependencies on CSI_I_ASSETS

Line 70: FROM csi_i_assets cia

66: cia.asset_quantity,
67: cia.object_version_number,
68: cia.fa_asset_id,
69: cia.active_end_date
70: FROM csi_i_assets cia
71: WHERE cia.instance_id = p_instance_id
72: AND cia.fa_asset_id = p_asset_id
73: AND sysdate BETWEEN nvl(cia.active_start_date, sysdate-1) AND nvl(cia.active_end_date, sysdate+1);
74:

Line 77: FROM csi_i_assets cia

73: AND sysdate BETWEEN nvl(cia.active_start_date, sysdate-1) AND nvl(cia.active_end_date, sysdate+1);
74:
75: CURSOR uniq_fa_cur(p_instance_id in number) IS
76: SELECT cia.fa_asset_id
77: FROM csi_i_assets cia
78: WHERE instance_id = p_instance_id
79: AND sysdate BETWEEN nvl(cia.active_start_date, sysdate-1) AND nvl(cia.active_end_date, sysdate+1);
80:
81: CURSOR pending_txn_cur(p_instance_id in number) is

Line 104: FROM csi_i_assets cia

100: ------------------------------------------------------------
101:
102: CURSOR pending_mass_add_cur(p_instance_id in number) IS
103: SELECT cia.fa_mass_addition_id
104: FROM csi_i_assets cia
105: WHERE instance_id = p_instance_id
106: AND fa_asset_id is null
107: AND sysdate BETWEEN nvl(cia.active_start_date, sysdate-1) AND nvl(cia.active_end_date, sysdate+1);
108: