DBA Data[Home] [Help]

APPS.CSI_INTERFACE_PKG dependencies on CSI_I_ORG_ASSIGNMENTS

Line 3785: FROM csi_i_org_assignments

3781: SELECT instance_ou_id,
3782: object_version_number
3783: INTO px_org_units_tbl(l_ind).instance_ou_id,
3784: px_org_units_tbl(l_ind).object_version_number
3785: FROM csi_i_org_assignments
3786: WHERE instance_id = px_org_units_tbl(l_ind).instance_id
3787: AND operating_unit_id = px_org_units_tbl(l_ind).operating_unit_id
3788: AND relationship_type_code = px_org_units_tbl(l_ind).relationship_type_code;
3789: EXCEPTION

Line 3797: FROM csi_i_org_assignments

3793: END;
3794: ELSE
3795: SELECT object_version_number
3796: INTO px_org_units_tbl(l_ind).instance_ou_id
3797: FROM csi_i_org_assignments
3798: WHERE instance_ou_id = px_org_units_tbl(l_ind).instance_ou_id;
3799: END IF;
3800: END LOOP;
3801: END IF;