APPS.CSI_UTL_PKG dependencies on CSI_I_ORG_ASSIGNMENTS

Line 103: FROM csi_i_org_assignments

99: api_log('get_org_obj_ver_num');
100:
101: SELECT object_version_number
102: INTO l_obj_ver_num
103: FROM csi_i_org_assignments
104: WHERE instance_ou_id = p_instance_ou_id;
105: RETURN l_obj_ver_num;
106: EXCEPTION
107: WHEN no_data_found THEN

Line 207: FROM csi_i_org_assignments

203: SELECT object_version_number,
204: instance_ou_id
205: INTO x_obj_version_number,
206: x_instance_ou_id
207: FROM csi_i_org_assignments
208: WHERE instance_id = p_instance_id
209: AND operating_unit_id = p_operating_unit_id
210: AND relationship_type_code = p_rel_type_code
211: AND ((active_end_date is null ) OR

Line 3911: FROM csi_i_org_assignments

3907: */
3908: BEGIN
3909: SELECT instance_ou_id
3910: INTO l_instance_ou_id
3911: FROM csi_i_org_assignments
3912: WHERE instance_id = p_txn_line_detail_rec.instance_id
3913: AND relationship_type_code = p_txn_org_assgn_tbl(j).relationship_type_code;
3914: -- AND operating_unit_id = p_txn_org_assgn_tbl(j).operating_unit_id; for 4293740
3915: EXCEPTION

Line 3924: FROM csi_i_org_assignments

3920:
3921: BEGIN
3922: SELECT instance_ou_id
3923: INTO l_instance_ou_id
3924: FROM csi_i_org_assignments
3925: WHERE instance_id = p_txn_line_detail_rec.instance_id
3926: AND relationship_type_code = p_txn_org_assgn_tbl(j).relationship_type_code
3927: AND operating_unit_id = p_txn_org_assgn_tbl(j).operating_unit_id
3928: AND (sysdate > nvl(active_start_date, sysdate-1)

Line 5256: FROM csi_i_org_assignments

5252:
5253: BEGIN
5254: SELECT instance_ou_id
5255: INTO l_instance_ou_id_check
5256: FROM csi_i_org_assignments
5257: WHERE instance_id = l_instance_id
5258: AND relationship_type_code = x_upd_org_units_tbl(l_upd_org).relationship_type_code
5259: AND ((active_end_date is null ) OR (active_end_date > sysdate)); -- Added for the bug 7333901
5260:

Line 5341: FROM csi_i_org_assignments

5337: SELECT instance_ou_id ,
5338: object_version_number
5339: INTO x_cre_org_units_tbl(l_cre_org).instance_ou_id,
5340: x_cre_org_units_tbl(l_cre_org).object_version_number
5341: FROM csi_i_org_assignments
5342: WHERE instance_id = l_instance_id
5343: AND relationship_type_code = x_cre_org_units_tbl(l_cre_org).relationship_type_code;
5344: -- and operating_unit_id = x_cre_org_units_tbl(l_cre_org).operating_unit_id; for 4293740
5345: