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 3869: FROM csi_i_org_assignments

3865: */
3866: BEGIN
3867: SELECT instance_ou_id
3868: INTO l_instance_ou_id
3869: FROM csi_i_org_assignments
3870: WHERE instance_id = p_txn_line_detail_rec.instance_id
3871: AND relationship_type_code = p_txn_org_assgn_tbl(j).relationship_type_code;
3872: -- AND operating_unit_id = p_txn_org_assgn_tbl(j).operating_unit_id; for 4293740
3873: EXCEPTION

Line 3882: FROM csi_i_org_assignments

3878:
3879: BEGIN
3880: SELECT instance_ou_id
3881: INTO l_instance_ou_id
3882: FROM csi_i_org_assignments
3883: WHERE instance_id = p_txn_line_detail_rec.instance_id
3884: AND relationship_type_code = p_txn_org_assgn_tbl(j).relationship_type_code
3885: AND operating_unit_id = p_txn_org_assgn_tbl(j).operating_unit_id
3886: AND (sysdate > nvl(active_start_date, sysdate-1)

Line 5262: FROM csi_i_org_assignments

5258: SELECT instance_ou_id ,
5259: object_version_number
5260: INTO x_cre_org_units_tbl(l_cre_org).instance_ou_id,
5261: x_cre_org_units_tbl(l_cre_org).object_version_number
5262: FROM csi_i_org_assignments
5263: WHERE instance_id = l_instance_id
5264: AND relationship_type_code = x_cre_org_units_tbl(l_cre_org).relationship_type_code;
5265: -- and operating_unit_id = x_cre_org_units_tbl(l_cre_org).operating_unit_id; for 4293740
5266: